Search⌘ K
AI Features

Problem: Only Keep Interesting Groups

Explore how to write SQL queries that group people by city, calculate average ages, and filter results to keep only cities with an average age less than 28. This lesson helps you refine database questions by using grouping, aggregation, and filtering techniques.

We'll cover the following...

Write a query that:

  • Groups people by city. ...