最近看SQLZOO 自己也是在学习边学习边参考答案。
SQL的设置是mysql,,,如果选用MSsql可能出错(MicrosoftSQL)
SELECT basics(这简单就是改词)
1.
Modify it to 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
英语不会的兄弟谷歌浏览器能翻译网页,还可自己安装插件沙拉查词,以后写一下安装插件