sql练习题答案2（sqlzoo-3.SELECT from Nobel Tutorial 8-14题）

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

8.Show the year, subject, and name of Physics winners for 1980 together with the Chemistry winners for 1984.

select yr,subject,winner from nobel
where (yr='1980' and subject='physics')
or (yr='1984' and subject='chemistry')

9.Show the year, subject, and name of winners for 1980 excluding Chemistry and Medicine

select yr,subject,winner from nobel
where yr='1980' 
and subject<>'Chemistry' 
and subject<>'Medicine'

10.Show year, subject, and name of people who won a 'Medicine' prize in an early year (before 1910, not including 1910) together with winners of a 'Literature' prize in a la