1. Learn
    2. /
  2. Courses
    3. /
  3. Joining Data in SQL
Connected

Exercise

Choosing your join

Now that you're fully equipped to use joins, try a challenge problem to test your knowledge!

You will determine the names of the five countries and their respective regions with the lowest life expectancy for the year 2010. Use your knowledge about joins, filtering, sorting and limiting to create this list!

Instructions

100 XP
  • Complete the join of countries AS c with populations as p.
  • Filter on the year 2010.
  • Sort your results by life expectancy in ascending order.
  • Limit the result to five countries.