SQLZOO练习记录：SELECT from Nobel

重新复习数据库，继续把不熟悉的题目记录下来。

11. Find all details of the prize won by PETER GRÜNBERG.
查找PETER GRÜNBERG获奖的所有详情

select * from nobel
	where winner='PETER GRÜNBERG'
# 不太理解Ü非ASCII字符的影响是什么

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

字符串含有单引号 可以用双引号代替

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

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

# DESC 年份降序排列
select winner,yr,subject from nobel
	where winner like 'Sir%'
		order by yr DESC,winner

14. The expression subject IN (‘Chemistry’,‘Physics’) can be used as a value - it will be 0 or 1.
表达式subject IN（‘Chemistry’,‘Physics’）可以用作值-它将为0或1。
Show the 1984 winners and subject ordered by subject and winner name; but list Chemistry and Physics last.
显示1984年获奖者和按主题和获奖者姓名排序的主题；但化学和物理排在最后。

0 1为顺序排序 因此’Chemistry’和’Physics’会排在后面
相当于升序排列

select winner,subject from nobel
	where yr=1984
	order by
		case
		when subject not in('Chemistry','Physics') then 0
		else 1 end,
	subject,winner