Module Overview

What You’ll Learn

• Summarize data
• Group related records
• Filter grouped results

💡 Why this module matters: Individual rows are rarely the point, most real business questions ask for a summary: total sales per region, average order size per customer. GROUP BY is what turns a raw table into that kind of report.

What’s Covered

• GROUP BY, collapsing rows into groups based on shared column values.
• HAVING, filtering groups themselves, after they’ve been formed, not individual rows.
• Aggregate queries, combining GROUP BY with the aggregate functions from Module 7.
• Multiple-column grouping, grouping by more than one column at once.
• DISTINCT with aggregates, counting or aggregating only unique values within a group.

Hands-On

By the end of this module, you’ll build department summaries, sales reports, customer statistics, and product analysis, real summary reports built entirely from GROUP BY and aggregate functions.

Next module shifts focus from summarizing one table to connecting several, how real data relates across tables in the first place.