sql - ORA-00934 : group function is not allowed here 00934. 00000 - "group function is not allowed here"

Question

问题是:给出总工资大于 15000 的每个办公室(kantoor)，给出平均工资和办公室名称。使用分句使用内连接

这是我当前的查询:

SELECT      OFF.OFFICENR,
            OFF.NAME AS OFFICE,
            AVG(SAL)
FROM        OFFICE OFF INNER JOIN EMPLOYEE EMP USING (OFFICENR)
WHERE       SUM((SAL) >= 15000)                 **<---line 29**
GROUP BY    OFF.OFFICENR, OFF.NAME;      

查询输出为:

ORA-00934: group function is not allowed here 00934. 00000 - "group function is not allowed here" *Cause:
*Action: Error at Line: 29 Column: 13

Answer 1

您应该为此使用 HAVING:

SELECT      OFF.OFFICENR,
            OFF.NAME AS OFFICE,
            AVG(SAL)
FROM        OFFICE OFF 
INNER JOIN  EMPLOYEE EMP USING (OFFICENR)
GROUP BY    OFF.OFFICENR, OFF.NAME
HAVING      SUM(SAL) >= 15000;