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