CASE WHEN - Conditional Logic

CASE WHEN adds if/else logic directly in your SQL queries.

Structure:

CASE
    WHEN condition THEN result
    WHEN condition THEN result
    ELSE default_result
END

Example - categorize salaries:

SELECT first_name,
    CASE WHEN salary > 100000 THEN 'High'
         WHEN salary > 60000 THEN 'Mid'
         ELSE 'Low'
    END AS tier
FROM employees;

CASE WHEN is incredibly powerful for creating categories, labels, and conditional calculations right in your query.