xuesql
菜机懵新
这个作者很懒,什么都没留下…
展开
-
SQL Lesson 8: 关于特殊关键字 NULLs
1.【复习】找到雇员里还没有分配办公室的(列出名字和角色就可以)SELECT name,role FROM employees where building is null ;2.【难题】找到还没有雇员的办公室SELECT building_name FROM buildings where building_name not in(select building from Employees where building is not null);...原创 2021-12-09 11:20:51 · 426 阅读 · 0 评论 -
SQL Lesson 9: 在查询中使用表达式
1.【计算】列出所有的电影ID,名字和销售总额(以百万美元为单位计算)SELECT Id,Title,(domestic_sales+international_sales)/1000000FROM MoviesLEFT JOIN BoxofficeON id=movie_id;2.【计算】列出所有的电影ID,名字和市场指数(Rating的10倍为市场指数)SELECT Id,Title,Rating*10FROM MoviesLEFT JOIN BoxofficeON ...原创 2021-12-08 18:10:03 · 729 阅读 · 0 评论 -
SQL Lesson 10: 在查询中进行统计I (Pt. 1)
1.【统计】找出就职年份最高的雇员(列出雇员名字+年份)SELECT name,Years_employed FROM employees order by Years_employed desc limit 1;2.【分组】按角色(Role)统计一下每个角色的平均就职年份SELECT role,avg(Years_employed) FROM employees group by role;3.【分组】按办公室名字总计一下就职年份总和SELECT Building,sum(Years_原创 2021-12-08 17:48:10 · 697 阅读 · 0 评论 -
SQL Lesson 11: 在查询中进行统计II (Pt. 2)
1.【统计】统计一下Artist角色的雇员数量SELECT count(name) FROM employees where role='Artist';2.【分组】按角色统计一下每个角色的雇员数量SELECT role,count(name) FROM employees group by role;3.【分组】算出Engineer角色的就职年份总计SELECT sum(Years_employed) FROM employees where role='Engineer';4..原创 2021-12-08 17:41:43 · 490 阅读 · 0 评论 -
SQL Lesson 12: 查询执行顺序
1.【复习】统计出每一个导演的电影数量(列出导演名字和数量)SELECT Director, count(title) FROM movies group by Director;2.【复习】统计一下每个导演的销售总额(列出导演名字和销售总额)SELECT Director,sum(Domestic_sales+International_sales) FROM movies join Boxoffice on id=movie_id group by Director;3.【难题】按导演.原创 2021-12-08 17:48:21 · 436 阅读 · 0 评论