CASE Statement

Conditional logic in SQL.

Example

-- Categorize users by age
SELECT name, CASE WHEN age >= 25 THEN 'Senior' ELSE 'Junior' END as age_group FROM users;