SQL grouping and group filters 1 question in 2 chapters

They do different jobs rather than being alternatives. Group by collects rows with matching keys into groups, while having filters those groups after aggregation. Where filters individual rows before that happens. For example, I first keep paid orders, then group them by customer, and finally keep customers whose total exceeds a threshold. Moving that total condition into where would be invalid at the same query level.