It's funny that, "GROUP BY ALL" makes a lot of sense but it had never crossed my mind before!