MySQL：查询每个部门的员工小时平均工资（显示部门名称、部门员工小时平均 工资）

介绍

涉及的表的结构

table department

用来表示部门信息的表，通过dno字段与其他表关联

mysql> select * from department;
+---------------------------+-----+--------+--------------+
| dname                     | dno | mgrssn | mgrstartdata |
+---------------------------+-----+--------+--------------+
| Economy Department        | 000 | 09     | 2020-03-01   |
| Sales Department          | 001 | 06     | 2017-06-01   |
| Human Resource Department | 010 | 12     | 2003-12-01   |
| Produce Department        | 011 | 14     | 2009-05-01   |
| Research Department       | 100 | 20     | 2026-09-01   |
+---------------------------+-----+--------+--------------+
5 rows in