【SQL】sqlzoo练习题The nobel table can be used to practice more subquery.

原地址：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 ')