<<<  Biggest than largest per 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

Compute, for every continent name, a count of how many countries in the continent are strictly more populous that the continent's largest country (by area). Order the results by continent, and do not omit results where the count is zero.

Query


...
Run query first