Grouping and Aggregating Data

This module introduces methods for grouping data within a query, aggregating the grouped data and filtering groups with HAVING. The module is designed to help the student grasp why a SELECT clause has restrictions placed upon column naming in the GROUP BY clause as well as which columns may be listed in the SELECT clause.

Lessons

• Using Aggregate Functions
• Using the GROUP BY Clause
• Filtering Groups with HAVING

Lab : Grouping and Aggregating Data

After completing this module, you will be able to:

• Write queries which summarize data using built-in aggregate functions.
• Use the GROUP BY clause to arrange rows into groups.
• Use the HAVING clause to filter out groups based on a search condition.