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

Exercise

Full join (3)

You'll now explore using two consecutive full joins on the three tables you worked with in the previous two exercises.

Instructions

100 XP
  • Complete a full join with countries on the left and languages on the right.
  • Next, full join this result with currencies on the right.
  • Use LIKE to choose the Melanesia and Micronesia regions (Hint: 'M%esia').
  • Select the fields corresponding to the country name AS country, region, language name AS language, and basic and fractional units of currency.