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 thecity
column, then applyAVG(age)
to each group.
The people
table
Get hands-on with 1400+ tech skills courses.