An AI explained SQL GROUP BY in four lines. One of them is wrong.
We asked Aria, our AI, how filtering works with GROUP BY. She answered in four lines and sounded completely sure about all of them:
1. WHERE filters rows before they are grouped.
2. HAVING filters the
logicwiz.hashnode.dev2 min read