-- 1. Introducing the world table of countries
SELECT population FROM world
WHERE name = 'Germany'
-- 2. Scandinavia
SELECT name, population FROM world
WHERE name IN ('Sweden', 'Norway', 'Denmark');
-- 3. Just the right size
SELECT name, area FROM world
WHERE area BETWEEN 200000 AND 250000
'SQL > Sqlzoo' 카테고리의 다른 글
[sqlzoo] SELECT from WORLD Tutorial 정답, 풀이 (0) | 2022.07.21 |
---|---|
[sqlzoo] SELECT Quiz 정답, 풀이 (0) | 2022.07.21 |