下面哪个语句关于GROUP BY 和HAVING语句的使用是正确的?()A、SELECT JOB_ID , D...
单项选择题下面哪个语句关于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;
