SQLZOO---Nobel quiz
数据表
nobel
3.Pick the code that shows the amount of years where no Medicine awards were given(查询有几年没有颁布医学奖)
select count( distinct yr)
from nobel
where yr not in (
select distinct yr
from nobel
where subject='medicine' )
6. Select the code which shows the years when a Medicine award was given but no Peace or Literature award was (查询有颁布医学奖但是没有和平或者文学奖的年份)
select distinct yr
from nobel
where subject='medicine'
and yr not in (