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;