SQLZOO习题2

https://sqlzoo.net/wiki/SELECT_from_Nobel_Tutorial/zh

--第一题
SELECT yr, subject, winner
FROM nobel
WHERE yr = 1950

--第二题
SELECT winner
FROM nobel
WHERE yr = 1962
AND subject='Literature'

--第三题
SELECT yr,subject
FROM nobel
WHERE winner='Albert Einstein'

--第四题
SELECT winner
FROM nobel
WHERE yr>=2000
AND subject='Peace'

--第五题
SELECT yr, subject ,winner
FROM nobel
WHERE yr BETWEEN 1980 AND 1989
AND subject='Literature'

--第六题
SELECT * 
FROM nobel
WHERE winner IN ('Theodore Roosevelt','Woodrow Wilson','Jimmy Carter')

--第七题
SELECT winner
FROM nobel
WHERE winner LIKE 'John%'

--第八题
SELECT *
FROM nobel
WHERE (yr=1980 AND subject='physics')
OR(yr=1984 AND subject='chemistry')

--第九题
SELECT *
FROM nobel
WHERE yr=1980
AND subject NOT IN ('Chemistry','Medicine')

--第十题
SELECT *
FROM nobel
WHERE (yr<1910 AND subject='Medicine')
OR (yr>=2004 AND subject='Literature')

--第十一题
SELECT *
FROM nobel
WHERE winner='PETER GRÜNBERG'

--第十二题(字符串里面的单引号要用两个单引号来表示)
SELECT *
FROM nobel
WHERE winner='EUGENE O''NEILL'

--第十三题
SELECT winner,yr,subject
FROM nobel
WHERE winner LIKE 'Sir%'
ORDER BY yr DESC,winner

--第十四题


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值