Reports often need labels that are not stored anywhere, like "High" for salaries above 80000 and "Low" for the rest. CASE WHEN is SQL's if/else: it returns a value based on conditions you list. Use it to bucket values, build custom sort orders, or count rows that match a condition inside SUM. MySQL also has IF(), but CASE is standard and works in every database.