Exercise

WHERE do people live?

In this exercise, you will strengthen your knowledge of subquerying by identifying capital cities in order of largest to smallest population.

Follow the instructions below to get the urban area population for capital cities only. You'll use the countries and cities tables displayed in the console to help identify columns of interest as you build your query.

Instructions

100 XP
  • Return the name, country_code and urbanarea_pop for all capital cities (not aliased).