<<< Number of countries per continent >>>
Scenario world
f35f7fece0cf0019765619c477c900ddd8131dbc27b32e9261f4ab7cdc49773c
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
Show the name of continents and the number of countries in that continent that have population at least 1 million.
{"rows":[["Africa",47],["Asia",43],["Caribbean",5],["Eurasia",2],["Europe",35],["North America",9],["Oceania",3],["South America",10]],"fields":[{"name":"continent","dataTypeID":1043},{"name":"nombre_de_pays","dataTypeID":20}],"affectedRows":0}
False
False