Tutorials

Using the HAVING clause to filter SQL grouped aggregates

The HAVING clause is like the WHERE filter, except for group aggregate calculations.
Get the data

For this lesson, download the following file, which is a SQLite database built from the U.S. Social Security Administration file of popular baby names:

Unzip it, and open the sqlite file using the SQLite client of your choice (e.g. DB Browser for SQLite)

Table of contents