Exercise

Outer challenge

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

In terms of life expectancy for 2010, determine the names of the lowest five countries and their regions.

Instructions

100 XP
  • Select country name AS country, region, and life expectancy AS life_exp.
  • Make sure to use LEFT JOIN, WHERE, ORDER BY, and LIMIT.