Session Ready
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.