Not sure this is consistently implemented on the major platforms. I'm going to go with:
CASE Fruit
WHEN 'Banana' THEN 'Yellow'
WHEN 'Raspberry' THEN 'Red'
ELSE '?'
END AS Colour
and
CASE
WHEN Score < 10 THEN 'You suck!'
WHEN Score < 50 THEN 'Need more practice'
WHEN Score < 90 THEN 'Not bad'
ELSE 'You need to get out more!'
END AS ScoreComment
Not sure this is consistently implemented on the major platforms. I'm going to go with:
and