https://sqlzoo.net/wiki/SELECT_from_Nobel_Tutorial/zh
--第一题
SELECT yr, subject, winner
FROM nobel
WHERE yr = 1950
--第二题
SELECT winner
FROM nobel
WHERE yr = 1962
AND subject='Literature'
--第三题
SELECT yr,subject
FROM nobel
WHERE winner='Albert Einstein'
--第四题
SELECT winner
FROM nobel
WHERE yr>=2000
AND subject='Peace'
--第五题
SELECT yr, subject ,winner
FROM nobel
WHERE yr BETWEEN 1980 AND 1989
AND subject='Literature'
--第六题
SELECT *
FROM nobel
WHERE winner IN ('Theodore Roosevelt','Woodrow Wilson','Jimmy Carter')
--第七题
SELECT winner
FROM nobel
WHERE winner LIKE 'John%'
--第八题
SELECT *
FROM nobel
WHERE (yr=1980 AND subject='physics')
OR(yr=1984 AND subject='chemistry')
--第九题
SELECT *
FROM nobel
WHERE yr=1980
AND subject NOT IN ('Chemistry','Medicine')
--第十题
SELECT *
FROM nobel
WHERE (yr<1910 AND subject='Medicine')
OR (yr>=2004 AND subject='Literature')
--第十一题
SELECT *
FROM nobel
WHERE winner='PETER GRÜNBERG'
--第十二题(字符串里面的单引号要用两个单引号来表示)
SELECT *
FROM nobel
WHERE winner='EUGENE O''NEILL'
--第十三题
SELECT winner,yr,subject
FROM nobel
WHERE winner LIKE 'Sir%'
ORDER BY yr DESC,winner
--第十四题