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.
This exercise is part of the course
Joining Data in SQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Select relevant fields
___
-- Inner join countries and populations, aliased, on code
___