Analize the following code: SELECT department_name, AVG(salary) as average_salary FROM employees JOIN department d ON e.department_id =…

Analize the following code:

SELECT department_name, AVG(salary) as average_salary
FROM employees
JOIN department d ON e.department_id = d.department_id
WHERE salary > (SELECT AVG(salary) FROM employees )
GROUP BY department_name
HAVING COUNT(*) > 2
ORDER BY average_salary desc

From the Sonali & Janata Bank Officer (IT) October 2023 – Written (MIST) exam, question 1 of 18.

More from this paper