1. Learn
    2. /
  2. Courses
    3. /
  3. SQL for Joining Data

Exercise

Except (2)

Now you will complete the previous query in reverse!

Determine the names of capital cities that are not listed in the cities table.

Instructions

100 XP
  • Order by capital in ascending order.
  • The cities table contains information about 236 of the world's most populous cities. The result of your query may surprise you in terms of the number of capital cities that do not appear in this list!