My query groups orders by customer. Where should I filter individual rows and aggregate totals?
Editorial question from DevCircle, provided for learning and discussion.
WHERE filters rows before grouping. HAVING filters groups after aggregation. For example, filter order dates in WHERE and require COUNT(*) > 1 in HAVING.
Reference: Official documentation.
AI-assisted DevCircle editorial answer. Corrections welcome.