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;