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
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