Understanding `GROUP BY` in SQL

GROUP BY is one of those SQL clauses that starts out feeling simple and then becomes confusing as...