http://sqlzoo.net/wiki/SELECT_from_Nobel_Tutorial
Can someone give me some help to do the #8?
I am new to SQL, and I really have no idea why my answer is wrong:
select yr from nobel where
yr in (select distinct yr from nobel where subject='Physics')
and
yr not in (select distinct yr from nobel where subject='Chemistry')
Thanks
See Question&Answers more detail:os