sqlzoo 练习3——SELECT from Nobel

sqlzoo-SELECT from Nobel Tutorial: https://sqlzoo.net/wiki/SELECT_from_Nobel_Tutorial

1、Change the query shown so that it displays Nobel prizes for 1950.

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

2、Show who won the 1962 prize for Literature.

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

3、Show the year and subject that ‘Albert Einstein’ won his prize.

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

4、Give the name of the ‘Peace’ winners since the year 2000, including 2000.

SELECT winner 
FROM nobel
WHERE yr >= 2000 
AND subject ='peace'

5、Show all details (yr, subject, winner) of the Literature prize winners for 1980