Exercise

WHERE do people live?

In this exercise, you will strengthen your knowledge of subquerying using WHERE. Follow the instructions below to get the urban area population for capital cities only. Explore the 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).