Nobel Quiz

1. 選擇代碼以顯示以C開頭，並以n結束獲獎者的名字。

SELECT winner FROM nobel
 WHERE winner LIKE 'C%' AND winner LIKE '%n'

2. 選擇代碼以顯示1950年到1960年間有多少個化學獎。

SELECT COUNT(subject) FROM nobel
 WHERE subject = 'Chemistry'
   AND yr BETWEEN 1950 and 1960

3. 選擇代碼以顯示有多少年沒有頒發醫學獎。

SELECT COUNT(DISTINCT yr) FROM nobel
 WHERE yr NOT IN (SELECT DISTINCT yr FROM nobel WHERE subject = 'Medicine')

4. 選擇你會從這個代碼獲得的結果。

SELECT subject, winner FROM nobel WHERE winner LIKE 'Sir%' AND yr LIKE '196%'

5. 選擇代碼以顯示哪一年沒有頒發物理獎，亦沒有頒發化學獎。

SELECT yr FROM nobel
 WHERE yr NOT IN(SELECT yr 
                   FROM nobel
                 WHERE subject IN ('Chemistry','Physics'))

6. 選擇代碼以顯示哪一年有頒發醫學獎，但沒有頒發和平或文學獎。

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')```

```sql

7. 選擇你會從這個代碼獲得的結果。

 SELECT subject, COUNT(subject) 
   FROM nobel 
  WHERE yr ='1960' 
  GROUP BY subject