text: /* SQLZOO: 3 SELECT from Nobel:
  http://sqlzoo.net/wiki/SELECT_from_Nobel_Tutorial */
  
  /* Ex1. Change the query shown so that it 
  displays Nobel prizes for 1950. */
  SELECT yr, subject, winner
  FROM nobel
  WHERE yr = 1950
  
  
  /* Ex2. Show who won the 1962 prize for Literature. */
  SELECT winner
  FROM nobel
  WHERE yr = 1962
    AND subject = 'Literature'
  
  
  /* Ex3. Show the year and subject that won 'Albert Einstein' his prize. */
  SELECT yr, subject
  FROM nobel
  WHERE winner = 'Albert Einstein'
  
  
  /* Ex4. Give the name of the 'Peace' winners since the year 2000, 
  including 2000. */
  SELECT winner
  FROM nobel
  WHERE subject = 'Peace'
    AND yr >= 2000
  
  
  /* Ex5. Show all details (yr, subject, winner) of the 
  Literature prize winners for 1980 to 1989 inclusive. */
  SELECT yr, subject, winner
  FROM nobel
  WHERE subject = 'Literature' 
    AND yr BETWEEN 1980 AND 1989
  
  
  /* Ex6. Show all details of the presidential winners:
  - Theodore Roosevelt
  - Woodrow Wilson
  - Jimmy Carter
  - Barack Obama */
  SELECT yr, subject, winner
  FROM nobel
  WHERE winner IN (
    'Theodore Roosevelt',
    'Woodrow Wilson',
    'Jimmy Carter',
    'Barack Obama')
  
  
  /* Ex7. Show the winners with first name John. */
  SELECT winner
  FROM nobel
  WHERE winner LIKE 'John %'
  
  
  /* Ex8. Show the Physics winners for 1980 together with the 
  Chemistry winners for 1984. */
  SELECT yr, subject, winner
  FROM nobel
  WHERE (subject = 'Physics' AND yr = 1980)
    OR (subject = 'Chemistry' AND yr = 1984)
  
  
  /* Ex9. Show the winners for 1980 excluding the Chemistry and Medicine. */
  SELECT yr, subject, winner
  FROM nobel
  WHERE yr = 1980
    AND subject NOT IN ('Chemistry', 'Medicine')
  
  
  /* Ex10. Show year, subject, and name of people who won a 'Medicine' prize in an 
  early year (before 1910, not including 1910) together with winners of a 'Literature'
  prize in a later year (after 2004, including 2004) */
  SELECT yr, subject, winner
  FROM nobel
  WHERE (subject = 'Medicine' AND yr < 1910)
    OR (subject = 'Literature' AND yr >= 2004)
  
  
  /* Ex11. Find all details of the prize won by PETER GRÜNBERG. */
  SELECT *
  FROM nobel
  WHERE winner = 'Peter Grünberg'
  
  
  /* Ex12. Find all details of the prize won by EUGENE O'NEILL. */
  SELECT *
  FROM nobel
  WHERE winner = 'Eugene O''neill'
  
  
  /* Ex13. Knights in order
  List the winners, year and subject where the winner starts with Sir. 
  Show the the most recent first, then by name order. */
  SELECT winner, yr, subject
  FROM nobel
  WHERE winner LIKE 'Sir %'
  ORDER BY yr DESC, winner
  
  
  /* Ex14. The expression subject IN ('Chemistry','Physics') 
  can be used as a value - it will be 0 or 1.
  Show the 1984 winners and subject ordered by 
  subject and winner name; but list Chemistry and Physics last. */
  SELECT winner, subject
  FROM nobel
  WHERE yr = 1984
  ORDER BY 
    subject IN ('Chemistry', 'Physics'),
    subject,
    winner
  