sqlzoo介绍以及习题详解（01）——SELECT basics

简介

一个在线练习sql的绝佳地方，网址：sqlzoo,每一次尝试都能获得及时反馈。

---

切换SQL Engine

点击右上角的设置按钮，选择自己想要的SQL Engine.

开始刷题

链接地址
1.show the population of Germany
SELECT population FROM world WHERE name = 'Germany'

2.Show the name and the population for ‘Sweden’, ‘Norway’ and ‘Denmark’.
SELECT name, population FROM world WHERE name IN ('Sweden', 'Norway', 'Denmark')

3.show the country and the area for countries with an area between 200,000 and 250,000.
SELECT name, area FROM world WHERE area BETWEEN 200000 AND 250000