SQLZOO练习-- SELECT from Nobel Tutorial（含题目翻译）

知识点

运算符、and/or、order by、in、转义字符\

 

数据表

nobel

 

 

题目内容

1.Change the query shown so that it displays Nobel prizes for 1950.(查询1950年的诺贝尔奖信息)

select yr, subject, winner from nobel
where yr = 1950
 

 
 
2.Show who won the 1962 prize for Literature.(查询1962年的文学奖得主)

select winner from nobel
where yr = 1962
and subject = 'Literature'

     
3.Show the year and subject that won 'Albert Einstein' his prize.(查询诺贝尔奖得主‘Albert Einstein’的获奖年份和学科)

select yr,subject from nobel
where winner = 'Albert Einstein'

 

4.Give