查询哪个部门的平均工资比公司的平均工资高 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 51 点赞 0 评论 77 浏览
