-- 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 |