SQL SELECT case when with nested selects
SQL SELECT case when with joins
SQL SELECT case when with subqueries
SQL SELECT case when with aggregate functions
SQL SELECT case when with multiple conditions