SELECT column_A,\n       decode(column_A,0,0,1) as bar\n  FROM fooTable