The SQL CASE Expression, Explained for Beginners

Beginner guide to SQL CASE WHEN THEN ELSE END: both forms of CASE, why the order of the WHEN clauses changes the answer, why WHEN col = NULL never matches, where a CASE can go in a query, and how analysts use it for cleaning, bucketing, flags and con