Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Job-ready SQL and database skills
·
Module 4
Aggregation and Grouping
1
Summarizing Data with Aggregate Functions
Use aggregate functions `COUNT`, `SUM`, `AVG`, `MIN`, and `MAX` to summarize data.
2
Grouping Data with `GROUP BY`
Group rows using `GROUP BY` to perform aggregate calculations on subsets of data.
3
Removing Duplicates with DISTINCT
Remove duplicate rows from results using the `DISTINCT` keyword.
4
Filtering Grouped Data with HAVING
Filter grouped data using the `HAVING` clause.
5
WHERE vs. HAVING: Filtering Data
Distinguish between the use cases for the `WHERE` clause and the `HAVING` clause.
6
Combining Aggregate Functions
Combine multiple aggregate functions in a single query.
Previous module
Joining Multiple Tables
Next module
Advanced Querying with Subqueries