[Solved] SQLZOO Nobel Tutorial #8

by


All,
I got it solved by myself.

select distinct yr from nobel 
where 
subject="Physics" and yr not in 
(select distinct yr from nobel where subject="Chemistry")

Thanks

I also find a way to reveal the answer of those questions(at least some of them)
just append ?answer=1 to the url, you may be able to get an answer page.
Hope this works!

0

solved SQLZOO Nobel Tutorial #8