继续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 %'