SQL CASE文の書き方

WHENの後に評価させる式を書く

SELECT (CASE
WHEN expression1 = '0' OR expression2 = '0' THEN 'hoge'
WHEN expression1 = '1' OR expression2 = '1' THEN 'fuga'
ELSE 'piyo' END) AS fieldname
FROM tablename