Part 1 of 5 · 1 min read
Why this page comes first
In this module you will
- Use COUNT, SUM, AVG, MIN and MAX correctly against a table.
- Group rows with GROUP BY and compute one aggregate per group.
- Explain why HAVING filters groups, while WHERE filters rows, and why that difference matters.
- Spot a query that incorrectly mixes a grouped column with a non-grouped one.
Nearly every real report asks a question about many rows at once, not one row at a time. This page covers the tools that answer "how many," "how much," and "grouped by what," which later modules on analytics and reporting lean on constantly.