Someone kindly poined out http://sqlzoo.net when I asked about other interactive SQL resourses.
I was moving right along and feeling pretty good about what I have learned until I hit question 3a. on http://sqlzoo.net/1b.htm.
In an attempt to get he correct answer I have been doing quite a bit of research and cannot figure it out. I may be missing something but can't find the answer on the page.
Basically I have to figure out In which years was the Physics prize awarded but no Chemistry prize. This is to be a select statement from a single table. I have been reading about recursive joins and subqueries but cannot come up with the best answer.
As always, any help that can be provided is appreciated.