CASE Expressions
3 / 13
EasyOutput prediction

Simple CASE (equality form)

Given this table (orders):

idstatus
1shipped
2pending
3returned

What does this query return?

SELECT id,
       CASE status
         WHEN 'shipped'  THEN 'Done'
         WHEN 'pending'  THEN 'Waiting'
         ELSE 'Other'
       END AS label
FROM orders;

← → arrow keys to navigate

Sign in to save your progress.