Tag archive
Commands grouped around the same concept, pattern, or recurring problem.
Turn distinct row values into separate columns using `CASE WHEN` inside an aggregate.