Only Keep Interesting Groups
Explore how to filter grouped data in SQL using the HAVING clause. Understand how HAVING differs from WHERE and apply it to keep only relevant groups based on aggregate conditions such as average values.
We'll cover the following...
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
HAVINGto filter grouped results. ...