A、SELECT JOB_ID , DEPARTMENT_ID , AVG(SALARY)
FROM EMPLOYEES GROUP BY JOB_ID
HAVING AVG(SALARY) > 3000;
B、SELECT JOB_ID , DEPARTMENT_ID , AVG(SALARY)
FROM EMPLOYEES GROUP BY JOB_ID ,DEPARTMENT_ID
HAVING AVG(SALARY) > 3000;
C、SELECT JOB_ID , DEPARTMENT_ID , AVG(SALARY)
FROM EMPLOYEES GROUP BY AVG(SALARY)
HAVING AVG(SALARY) > 3000;
D、SELECT JOB_ID , DEPARTMENT_ID , AVG(SALARY)
FROM EMPLOYEES GROUP BY JOB_ID , DEPARTMENT_ID
HAVING SALARY > 3000;