sql练习题答案1（sqlzoo-3.SELECT from Nobel Tutorial 1-7题）

零基础学习sql，基础入门练习题SELECT from Nobel Tutorial - SQLZOO

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

select * 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 won 'Albert Einstein' 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 subject='peace'
and yr>=2000

5,.Show all details (