<<<  Biggest country in each continent  >>>

Scenario world

See details on the model

In this scenario, we have a single table world in which each row describes a country. The table contains the following attributes:

  • name of type VARCHAR(50) NOT NULL, the name of the country (e.g. France)
  • continent of type VARCHAR(60), in which continent is the country in (e.g. Europe)
  • area of time DECIMAL(10) the area of the country in square kilometer
  • population of type DECIMAL(11) the number of inhabitants
  • gdp of type DECIMAL(14) the Gross Domestic Product
  • capital of type VARCHAR(60) the name of the capital city
  • tld of type VARCHAR(5) the Top Level Domain of the country (the last part of the domain names of the country, e.g. .fr for France)
  • flag of type VARCHAR(255) an url of the flag of the country

Question

A second manner to perform subqueries is to put a query in the WHERE. For this exercise, you probably want to do something like:

SELECT continent, name
 FROM world w
WHERE w.area IN (BIGGEST_SIZE)

where BIGGEST_SIZE retrieves the name of the country whose size is the biggest among the countries c where c.continent = w.continent.

Note that we can also use the variant NOT IN in this type of subqueries

Query


...
Run query first