Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
7. Joining tables


Good. The last important thing we need to test is joining tables.


Take a look at another table we've prepared: gdp_per_capita. GDP per capita is a statistical measure of a region's economic performance. Our table has two columns: city and gdp_value.

For each city, show a single row with three columns: name of the city, usd_spent, and gdp_value.