WHERE 与 HAVING

WHERE 筛行、HAVING 筛组——一条查询的执行顺序是 FROM → WHERE → GROUP BY → HAVING → SELECT → ORDER BY。逐帧观察分组前后的两次过滤各自丢掉了什么。 SQLite 方言演示。