SELECT Quiz/ja
From SQLZoo
Language: | English • 日本語 • 中文 |
---|
SQLの基本構文の確認テスト
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 | |
... |
このテーブルを表示するコードを選ぶ。
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
このコードの出力結果を選ぶ:
SELECT name, population
FROM world
WHERE name LIKE "Al%"
Albania |
Algeria |
%bania | 3200000 |
%geria | 32900000 |
Al | 0 |
Albania | 3200000 |
Albania | 3200000 |
Algeria | 32900000 |
A または 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'
このクエリーの出力結果を選ぶ。
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 |
これは world テーブルの最初の数行:
このコードから得られる結果を選ぶ:
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 |
面積が50000を超えかつ人口が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
China, Australia, Nigeria, 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')