> You can easily change it to make `group by` behave much better Change what? Make "group by" behave better how? > `having` redundant with `where` They filte

> You can easily change it to make `group by` behave much better Change what? Make "group by" behave better how? > `having` redundant with `where` They filter different things, how do you make `where` perform both jobs? > like it should always have been if you just evaluate from start to end, without any hidden reordering. The only "hidden reordering" is an optimisation.