Skip to content

Instantly share code, notes, and snippets.

@EricaJoy

EricaJoy/gist:9125541

Created February 20, 2014 23:28
Show Gist options
  • Save EricaJoy/9125541 to your computer and use it in GitHub Desktop.
Save EricaJoy/9125541 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
# Solution to last question on http://sqlzoo.net/wiki/SELECT_from_Nobel_Tutorial
SELECT DISTINCT yr
FROM nobel
WHERE subject = 'Physics'
AND
yr NOT IN
(SELECT yr
FROM nobel
WHERE subject='Chemistry')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment