OCP CBT Question 530

Please solve the following question.

You need to find departments where the average salary of employees is greater than $8000. Which SQL statement will achieve this?

EMPLOYEES Table Sample Data (relevant columns)
EMPLOYEE_ID SALARY DEPARTMENT_ID
----------- ------ -------------
100         24000  90
101         17000  90
102         17000  90
103         9000   60
104         6000   60
105         4800   60
106         4200   60
107         NULL   60
108         10000  100
109         12000  100
110         7000   NULL

SELECT department_id, AVG(salary) FROM employees WHERE AVG(salary) > 8000 GROUP BY department_id;

SELECT department_id, AVG(salary) FROM employees GROUP BY department_id HAVING AVG(salary) > 8000;

SELECT department_id, AVG(salary) FROM employees GROUP BY department_id WHERE salary > 8000;

SELECT department_id, SUM(salary)/COUNT(employee_id) FROM employees GROUP BY department_id HAVING SUM(salary)/COUNT(employee_id) > 8000;