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

Exercise

Joining multiple tables

You've seen that the ability to combine multiple joins using a single query is a powerful feature of SQL.

Suppose you are interested in the relationship between fertility and unemployment rates. Your task in this exercise is to join tables to return the country name, year, fertility rate, and unemployment rate in a single result from the countries, populations and economies tables.

Instructions 1/2

undefined XP
  • 1
    • Do an inner join of countries AS c (left) with populations AS p (right), on code.
    • Select name and fertility_rate.
  • 2
    • Chain an inner join with the economies table AS e, on code.
    • Select year and unemployment_rate from the economies table.