The nobel table can be used to practice more subquery./zh
諾貝爾獎:子查詢
1.紅十字國際委員會 (International Committee of the Red Cross) 曾多次獲得和平獎。 試找出與紅十字國際委員會同年得獎的文學獎(Literature)得獎者和年份。
SELECT winner,yr
FROM nobel
where subject='Literature'
and yr in (select yr
from nobel
where winner = 'International Committee of the Red Cross'
and subject='Peace')
2.日本物理學家益川敏英 (Toshihide Maskawa) 曾獲得物理獎。同年還有兩位日本人一同獲得物理獎。試列出這2位日本人的名稱。
select distinct winner
from nobel
where subject='Physics '
and yr in (select yr
from nobel
where winner='Toshihide Maskawa')
and winner!='Toshihide Maskawa'
3.首次頒發的經濟獎 (Economics)的得獎者是誰?
select winner
from nobel
where yr