CASE 
 WHEN condition THEN result 
 [ WHEN condition THEN result ]... 
 [ ELSE result ] 
END