查询哪个部门的平均工资比公司的平均工资高 select department_id, round(avg(salary),2) avg_salfrom employeesgroup by department_id having avg(salary), (select avg(salary) from employees)order by 2; Other 2023-10-15 150 点赞 2 评论 227 浏览
