Aggregate Functions: COUNT, SUM, AVG and GROUP BY

A single SQL query can turn millions of messy rows into one clear sentence. A store manager sees “yesterday’s total sales,” not chaos. Today, we’ll zoom in on how COUNT, SUM, and AVG secretly do that work—and why one tiny mistake can flip your results on their head.

Most dashboards you’ve seen—“top 10 products,” “revenue by region,” “average response time today”—are powered by the same quiet duo: aggregate functions plus GROUP BY. This is where SQL stops thinking row-by-row and starts thinking in crowds. GROUP BY decides which rows belong together; the aggregates summarize each crowd into a single, useful fact.

This is also where subtle mistakes become expensive. One misplaced column in GROUP BY, and “sales per day” silently turns into “sales per store per day per cashier.” Put a filter in WHERE instead of HAVING, and you might exclude rows before they’re counted, changing totals without any error message.