SQLZ00答案2:SELECT_from_Nobel_Tutorial/zh答案

最新推荐文章于 2025-08-04 23:14:52 发布

QMai

最新推荐文章于 2025-08-04 23:14:52 发布

阅读量213

点赞数

CC 4.0 BY-SA版权

分类专栏： MYSQL 文章标签： mysql

本文链接：https://blog.csdn.net/weixin_38427967/article/details/108556272

MYSQL 专栏收录该内容

6 篇文章

订阅专栏

这是一个关于如何使用SQL从Nobel数据集中提取信息的教程，主要针对初学者，涵盖基础的SELECT语句和数据查询操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

sqlzoo.net/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 subject='Peace' and yr>=2000

select yr,subject,winner from nobel 
where subject='Literature' and yr between 1980 and 1989

select *from nobel 
where subject='Literature' and yr between 1980 and 1989

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  subject not in('Chemistry','Medicine') and yr=1980

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

SELECT winner, subject
 FROM nobel
 WHERE yr=1984
 ORDER BY subject in('Chemistry','Physics'),subject,winner