SQLZOO: SELECT from Nobel Tutorial/zh

11. Find all details of the prize won by PETER GRÜNBERG

select *
from nobelwhere 
winner = 'PETER GRÜNBERG'

注意 Ü，没研究出来怎么打，直接复制的

12. 查找尤金•奧尼爾EUGENE O'NEILL得獎的所有細節 Find all details of the prize won by EUGENE O'NEILL

select *
from nobel
where winner='EUGENE O\'NEILL'

14. The expression subject IN ('Chemistry','Physics') can be used as a value - it will be 0 or 1.

Show the 1984 winners and subject ordered by subject and winner name; but list Chemistry and Physics last.

SELECT winner, subject
FROM nobel
WHERE yr=1984
ORDER BY subject IN ('Physics','Chemistry'),subject,winner