Simple CASE (equality form)

Question

Accepted Answer

The simple CASE form places the expression to test right after CASE, then each WHEN provides a value to compare against using equality. CASE status WHEN 'shipped' is equivalent to CASE WHEN status = 'shipped'. 'returned' doesn't match any WHEN, so the ELSE branch returns 'Other'.