Welcome to module 8.

In this module, we explore how to apply the GROUP BY clause, a fundamental feature of SQL queries that groups rows based on specified columns. This clause is also used for queries that include one or more aggregate functions like sum() or average (). You will learn about these in the next module.

You'll learn how to use GROUP BY to aggregate data and perform operations like counting, summing, averaging, and more across groups.

We will demonstrate different use cases and scenarios that require the GROUP BY clause through a series of illustrative examples and interactive demos.

As usual, each lesson includes several examples and demos, plus a homework assignment to reinforce your learning.

All example code is available at the end of the course outline.