SELECT Quiz
Language: | English • 日本語 • 中文 |
---|
Some questions concerning basic SQL statements
name | region | area | population | gdp |
---|---|---|---|---|
Afghanistan | South Asia | 652225 | 26000000 | |
Albania | Europe | 28728 | 3200000 | 6656000000 |
Algeria | Middle East | 2400000 | 32900000 | 75012000000 |
Andorra | Europe | 468 | 64000 | |
... |
Select the code which produces this table
name | population |
---|---|
Bahrain | 1234571 |
Swaziland | 1220000 |
Timor-Leste | 1066409 |
FROM world
SELECT name, population BETWEEN 1000000 AND 1250000
FROM name, population
WHERE population BETWEEN 1000000 AND 1250000
SELECT world
SELECT name, population
FROM world
WHERE population BETWEEN 1000000 AND 1250000
SELECT population BETWEEN 1000000 AND 1250000
FROM world
WHERE population BETWEEN 1000000 AND 1250000
SELECT name, population FROM world
Pick the result you would obtain from this code:
SELECT name, population
FROM world
WHERE name LIKE "Al%"
Albania |
Algeria |
%bania | 3200000 |
%geria | 32900000 |
Al | 0 |
Albania | 3200000 |
Albania | 3200000 |
Algeria | 32900000 |
Select the code which shows the countries that end in A or L
SELECT name FROM world
WHERE name LIKE 'a%' AND name LIKE 'l%'
SELECT name FROM world
WHERE name LIKE 'a%' OR name LIKE 'l%'
SELECT name FROM world
WHERE name LIKE '%a' AND name LIKE '%l'
SELECT name FROM world
WHERE name LIKE '%a' OR 'l%'
SELECT name FROM world
WHERE name LIKE '%a' OR name LIKE '%l'
Pick the result from the query
SELECT name,length(name)
FROM world
WHERE length(name)=5 and region='Europe'
name | length(name) |
---|---|
Benin | 5 |
Lybia | 5 |
Egypt | 5 |
name | length(name) |
---|---|
Italy | 5 |
Egypt | 5 |
Spain | 5 |
name | length(name) |
---|---|
Italy | 5 |
Malta | 5 |
Spain | 5 |
name | length(name) |
---|---|
Italy | 5 |
France | 6 |
Spain | 5 |
name | length(name) |
---|---|
Sweden | 6 |
Norway | 6 |
Poland | 6 |
Here are the first few rows of the world table:
Pick the result you would obtain from this code:
name | region | area | population | gdp |
---|---|---|---|---|
Afghanistan | South Asia | 652225 | 26000000 | |
Albania | Europe | 28728 | 3200000 | 6656000000 |
Algeria | Middle East | 2400000 | 32900000 | 75012000000 |
Andorra | Europe | 468 | 64000 | |
... |
SELECT name, area*2 FROM world WHERE population = 64000
Andorra | 234 |
Andorra | 468 |
Andorra | 936 |
Andorra | 4680 |
Andorra | 936 |
Albania | 57456 |
Select the code that would show the countries with an area larger than 50000 and a population smaller than 10000000
SELECT name, area, population
FROM world
WHERE area < 50000 AND population < 10000000
SELECT name, area, population
FROM world
WHERE area < 50000 AND population > 10000000
SELECT name, area, population
FROM world
WHERE area > 50000 AND population < 10000000
SELECT name, area, population
FROM world
WHERE area > 50000 AND population > 10000000
SELECT name, area, population
FROM world
WHERE area = 50000 AND population = 10000000
Select the code that shows the population density of China, Australia, Nigeria and France
SELECT name, area/population
FROM world WHERE name IN ('China', 'Nigeria', 'France', 'Australia')
SELECT name, area/population
FROM world WHERE name LIKE ('China', 'Nigeria', 'France', 'Australia')
SELECT name, population/area
FROM world
WHERE name IN ('China', 'Nigeria', 'France', 'Australia')
SELECT name, population/area
FROM world
WHERE name LIKE ('China', 'Nigeria', 'France', 'Australia')
SELECT name, population
FROM world
WHERE name IN ('China', 'Nigeria', 'France', 'Australia')