题目链接：SELECT from Nobel Tutorial
1
SELECT yr, subject, winner FROM nobel
WHERE yr = 1950
2
SELECT winner FROM nobel
WHERE yr = 1962
AND subject = 'Literature'
3
select yr,subject from nobel
where winner = 'Albert Einstein'
4
select winner from nobel
where subject = 'Peace' and yr >= 2000
5
select * from nobel
where subject = 'Literature'
and yr between 1980 and 1989
6
SELECT * FROM nobel
WHERE winner
IN ('Theodore Roosevelt', 'Woodrow Wilson', 'Jimmy Carter',
'Barack Obama')
7
select winner from nobel
where winner like 'John%'
8
select * from nobel
where (subject = 'Physics' and yr=1980)
or (subject = 'Chemistry' and yr=1984)
9
select * from nobel
where subject not in ('Chemistry','Medicine') and yr = 1980
10
select * from nobel
where (subject = 'Medicine' and yr <1910)
or (subject = 'Literature' and yr>=2004)
11
select * from nobel
where winner = 'PETER GRUNBERG'
12
select * from nobel
where winner = 'EUGENE O\'NEILL'
13
select winner,yr,subject from nobel
where winner like 'Sir%'
order by yr DESC,winner
14
SELECT winner, subject FROM nobel
WHERE yr=1984
ORDER BY subject IN ('Physics','Chemistry'),subject,winner
