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

Exercise

Subquery inside select

In this exercise, you'll see how some queries can be written using either a join or a subquery.

You have seen previously how to use GROUP BY with aggregate functions and an inner join to get summarized information from multiple tables.

The code given in the first query selects the top nine countries in terms of number of cities appearing in the cities table. Recall that this corresponds to the most populous cities in the world. Your task will be to convert the second query to get the same result as the provided code.

Instructions 1/2

undefined XP
    1
    2
  • Submit the code to view the result of the provided query.