sqlzoo刷题笔记-04 | SELECT from Nobel

网址：https://sqlzoo.net/wiki/SELECT_from_Nobel_Tutorial

1、Change the query shown so that it displays Nobel prizes for 1950.显示 1950 年的诺贝尔奖。

SELECT yr, subject, winner
FROM nobel
WHERE yr = 1950

2、Show who won the 1962 prize for Literature.显示谁赢得了 1962 年的文学奖。

SELECT winner
FROM nobel
WHERE yr = 1962
AND subject = 'Literature'

3、Show the year and subject that won 'Albert Einstein' his prize.  显示 'Albert Einstein'获奖的年份和奖项类别。

SELECT yr, subject
FROM nobel
WHERE winner = 'Albert Einstein'

4、Give the name of the 'Peace' winners since the year 2000, including 2000.显示自2000年（包括2000年）以后获得诺贝尔和平奖的获奖人。

SELECT winner 
FROM nobel
WHERE yr >