sql-查找具有五个以上成员的每个部门的平均工资 [英] sql - find average salary for each department with more than five members

问题描述

不太确定如何获得这一点.我有一个职员表，我需要找到平均工资.我知道我可以使用use avg().但是，诀窍是我需要找到拥有5名以上职员的部门的平均值.我不确定是否应使用分组依据或使用方式.谢谢！

Not quite sure how to get this one. I have a staff table and I need to find the average salary. I know I can use use avg(). But the trick is I need to find the average for departments that have more than 5 staff members. I'm not sure if I should use group by or how to use it. Thanks!

    CREATE TABLE STAFF (STAFF_ID                    CHAR(3),
                        STAFF_NAME              CHAR(20),
                        GENDER                  CHAR(6),
                        DEPARTMENT              CHAR(20),
                        BOSS_ID                 CHAR(3)
                        SALARY                  NUMBER(8,2));

推荐答案

select DEPARTMENT,count(STAFF_ID) as CountStaff, avg(SALARY) as AVGSalary
from STAFF
group by DEPARTMENT
having count(STAFF_ID) > 5

这篇关于sql-查找具有五个以上成员的每个部门的平均工资的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！