Exercise

Subquery inside where (2)

Use your knowledge of subqueries in WHERE to get the urban area population for only capital cities.

Instructions

100 XP

Make use of the capital field in the countries table in your subquery.
Select the city name, country code, and urban area population fields.

Take Hint (-30 XP)