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

+ Recent posts