<<< Populous countries >>>
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
Select all country names having at least one million inhabitants.
{"rows":[["Afghanistan"],["Albania"],["Algeria"],["Angola"],["Argentina"],["Armenia"],["Australia"],["Austria"],["Azerbaijan"],["Bahrain"],["Bangladesh"],["Belarus"],["Belgium"],["Benin"],["Bolivia"],["Bosnia and Herzegovina"],["Botswana"],["Brazil"],["Bulgaria"],["Burkina Faso"],["Burundi"],["Cambodia"],["Cameroon"],["Canada"],["Central African Republic"],["Chad"],["Chile"],["China"],["Colombia"],["Congo, Democratic Republic of"],["Congo, Republic of"],["Costa Rica"],["Croatia"],["Cuba"],["Czech Republic"],["Denmark"],["Dominican Republic"],["Ecuador"],["Egypt"],["El Salvador"],["Equatorial Guinea"],["Eritrea"],["Estonia"],["Ethiopia"],["Finland"],["France"],["Gabon"],["Gambia"],["Georgia"],["Germany"],["Ghana"],["Greece"],["Guatemala"],["Guinea"],["Guinea-Bissau"],["Haiti"],["Honduras"],["Hungary"],["India"],["Indonesia"],["Iran"],["Iraq"],["Ireland"],["Israel"],["Italy"],["Jamaica"],["Japan"],["Jordan"],["Kazakhstan"],["Kenya"],["Kuwait"],["Kyrgyzstan"],["Laos"],["Latvia"],["Lebanon"],["Lesotho"],["Liberia"],["Libya"],["Lithuania"],["Macedonia"],["Madagascar"],["Malawi"],["Malaysia"],["Mali"],["Mauritania"],["Mauritius"],["Mexico"],["Moldova"],["Mongolia"],["Morocco"],["Mozambique"],["Myanmar"],["Namibia"],["Nepal"],["Netherlands"],["New Zealand"],["Nicaragua"],["Niger"],["Nigeria"],["North Korea"],["Norway"],["Oman"],["Pakistan"],["Panama"],["Papua New Guinea"],["Paraguay"],["Peru"],["Philippines"],["Poland"],["Portugal"],["Qatar"],["Romania"],["Russia"],["Rwanda"],["Saudi Arabia"],["Senegal"],["Serbia"],["Sierra Leone"],["Singapore"],["Slovakia"],["Slovenia"],["Somalia"],["South Africa"],["South Korea"],["South Sudan"],["Spain"],["Sri Lanka"],["Sudan"],["Swaziland"],["Sweden"],["Switzerland"],["Syria"],["Taiwan"],["Tajikistan"],["Tanzania"],["Thailand"],["Timor-Leste"],["Togo"],["Trinidad and Tobago"],["Tunisia"],["Turkey"],["Turkmenistan"],["Uganda"],["Ukraine"],["United Arab Emirates"],["United Kingdom"],["United States"],["Uruguay"],["Uzbekistan"],["Venezuela"],["Vietnam"],["Yemen"],["Zambia"],["Zimbabwe"]],"fields":[{"name":"name","dataTypeID":1043}],"affectedRows":0}
False
False