继续where语句的练习。
本节使用一个诺贝尔奖得主表：
nobel(yr, subject, winner)
练习题地址：http://www.sqlzoo.cn/1b.htm
练习题答案及分析：
1a. 显示1950诺贝尔奖得主.
SELECT yr, subject, winner
FROM nobel
WHERE yr = 1950
1b. 给出1962 文学奖获得者．
SELECT winner
FROM nobel
WHERE yr = 1962
AND subject = 'Literature'
2a. 显示'Albert Einstein'获奖的年份和奖项．
SELECT yr, subject FROM nobel
WHERE winner='Albert Einstein'
2b. 给出2000年以来（包含2000年）和平奖的得主．
SELECT winner FROM nobel
WHERE subject = 'Peace' and yr >=2000
2c. 给出1980 到 1989间文学奖获得者的所有信息．
SELECT * FROM nobel
WHERE subject = 'Literature'
AND yr BETWEEN 1980 AND 1989
2d. 给出获奖者为下列总统的所有信息． ('Theodore Roosevelt', 'Woodrow Wilson', 'Jed Bartlet', 'Jimmy Carter')
SELECT * FROM nobel
WHERE winner IN
('Theodore Roosevelt', 'Woodrow Wilson',
'Richard Nixon', 'Jimmy Carter')
2e. 名字的第一个字符为John的获奖者名称．
SELECT winner FROM nobel
WHERE winner LIKE 'John %'