1. Learn
    2. /
  2. Courses
    3. /
  3. SQL for Joining Data

Exercise

Final challenge (2)

Whoofta! That was challenging, huh?

Let's ease up a bit and calculate the average fertility rate for each region in 2015.

Instructions

100 XP
  • Include the name of region, its continent, and average fertility rate aliased as avg_fert_rate.
  • Sort based on avg_fert_rate ascending.
  • Remember that you'll need to GROUP BY all fields that aren't included in the aggregate function of SELECT.