Project: Group Things Together

Practice grouping rows and using aggregate functions on those groups.

We'll cover the following

Task

You want to find the average age of people in each city. Instead of looking at individual rows, you'll group them by city and calculate the average age within each group.

💡 Hint: Use GROUP BY to organize data into groups based on the city column, then apply AVG(age) to each group.

The people table

Get hands-on with 1400+ tech skills courses.