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...
We'll cover the following...
Write a query that:
Groups people by city. ...