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 descFrom the Sonali & Janata Bank Officer (IT) October 2023 – Written (MIST) exam, question 1 of 18.