Least You Need to Know: GROUP BY, Aggregation, and NULL Semantics
فتح الدرس
Aggregation questions are about partitioning rows into groups, then summarizing each group carefully. The common traps are filtering at the wrong stage, forgetting how `NULL` behaves, and accidentally duplicating rows before aggregating.