原地址:https://sqlzoo.net/wiki/The_nobel_table_can_be_used_to_practice_more_subquery./zh
上一篇:sqlzoo练习题SELECT within SELECT Tutorial
1.紅十字國際委員會 (International Committee of the Red Cross) 曾多次獲得和平獎。 試找出與紅十字國際委員會同年得獎的文學獎(Literature)得獎者和年份。
nobel(yr, subject, winner)
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 ')