下面哪个语句关于GROUP BY 和HAVING语句的使用是正确的?()

下面哪个语句关于GROUP BY 和HAVING语句的使用是正确的？()

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;

请帮忙给出正确答案和分析，谢谢！