text: -- Pick the code which shows the name of winner's names beginning with C and ending in n
  SELECT winner FROM nobel
   WHERE winner LIKE 'C%' AND winner LIKE '%n';
  
  -- Select the code that shows how many Chemistry awards were given between 1950 and 1960
  SELECT COUNT(subject) FROM nobel
   WHERE subject = 'Chemistry'
     AND yr BETWEEN 1950 and 1960;
  
  -- Pick the code that shows the amount of years where no Medicine awards were given
  SELECT COUNT(DISTINCT yr) FROM nobel
   WHERE yr NOT IN (SELECT DISTINCT yr FROM nobel WHERE subject = 'Medicine');
  
  -- This code will retrieve Sir John Eccles and Sir Frank Macfarlane with their Subjects:
  SELECT subject, winner FROM nobel WHERE winner LIKE 'Sir%' AND yr LIKE '196%';
  
  -- Select the code which would show the year when neither a Physics or Chemistry award was given
  SELECT yr FROM nobel
   WHERE yr NOT IN(SELECT yr 
                     FROM nobel
                   WHERE subject IN ('Chemistry','Physics'));
  
  -- Select the code which shows the years when a Medicine award was given but no Peace or Literature award was
  SELECT DISTINCT yr
    FROM nobel
   WHERE subject='Medicine' 
     AND yr NOT IN(SELECT yr FROM nobel 
                    WHERE subject='Literature')
     AND yr NOT IN (SELECT yr FROM nobel
                     WHERE subject='Peace');
  
  -- This code will retrieve all the subject and how many times they've been stored in 1960:
  SELECT subject, COUNT(subject) 
    FROM nobel 
   WHERE yr ='1960' 
   GROUP BY subject;
  