every now and then I forget the order of `where` and `group by`, SQL syntax certainly has it's counter-intutive quirks.