sqlzoo 之 nobel 错题集

12、查找尤金•奧尼爾EUGENE O'NEILL得獎的所有細節

我：

select yr , subject , winner from nobel 

where winner = 'eugene o'neill ' ;

无法查询。

正确：

select yr ,subject ,winner from nobel 

where winner = 'eugene o\'neill ';

 

13、列出爵士的獲獎者、年份、獎頁(爵士的名字以Sir開始)。先顯示最新獲獎者，然後同年再按名稱順序排列。

 我：

select winner , yr ,subject from nobel 

where winner like 'sir%' 

order by yr ,winner desc;

正确:

select winner ,yr, subject from nobel 

where winner like 'sir%'

order by yr desc ,winner asc;