【SQL】6.SQLZOO练习1--SELECT basics

题目链接：https://sqlzoo.net/wiki/SELECT_basics

select basics 1

SELECT population FROM world
WHERE name = 'Germany'

select basics 2

select name,population from world
where name in ('Sweden', 'Norway', 'Denmark')

select basics 3

SELECT name, area FROM world
WHERE area BETWEEN 200000 AND 250000