Search⌘ K
AI Features
Home
Courses
Learn SQL

Only Keep Interesting Groups

Explore how to refine grouped data by applying the HAVING clause in SQL. Learn to filter summaries such as cities where average age meets a condition, distinguishing HAVING from WHERE. This lesson helps you understand filtering groups after aggregation to focus on the most relevant data insights.

We'll cover the following...

You’ve grouped your data, now filter those results using HAVING. It works like WHERE, but for groups.

Goal

You’ll aim to:

  • Use HAVING to filter grouped results.

  • Keep only the summaries you care about. ...