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_employed) FROM employees group by Building;

4.【难题】每栋办公室按人数排名,不要统计无办公室的雇员

SELECT Building,count(name) c  FROM employees where building is not null group by Building order by c desc;