<<< Names of contries >>>
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 the name of all countries in Europe
{"rows":[["Albania"],["Andorra"],["Austria"],["Belarus"],["Belgium"],["Bosnia and Herzegovina"],["Bulgaria"],["Croatia"],["Czech Republic"],["Denmark"],["Estonia"],["Finland"],["France"],["Germany"],["Greece"],["Hungary"],["Iceland"],["Ireland"],["Italy"],["Kazakhstan"],["Latvia"],["Liechtenstein"],["Lithuania"],["Luxembourg"],["Macedonia"],["Malta"],["Moldova"],["Monaco"],["Montenegro"],["Netherlands"],["Norway"],["Poland"],["Portugal"],["Romania"],["San Marino"],["Serbia"],["Slovakia"],["Slovenia"],["Spain"],["Sweden"],["Switzerland"],["Ukraine"],["United Kingdom"],["Vatican City"]],"fields":[{"name":"name","dataTypeID":1043}],"affectedRows":0}
False
False