CASE WHEN Expressions

SQL has no if/else statements. When you need conditional logic inside a query, whether to classify rows, reorder results, or count only certain values, CASE is the tool for the job.

It evaluates conditions row by row and returns a value based on the first match, much like a series of if/else-if branches in a programming language.