CASE WHEN conditional_statement_1 THEN
  value_if_true
WHEN conditional_statement_2 THEN
  value_if_second_condition_true
ELSE
  default_result_if_no_conditions_met
END