Analyze the output of the following SQL : SELECT department_name, AVG(salary) AS average_salary FROM employees e JOIN departments d ON…

Analyze the output of the following SQL :

SELECT department_name, AVG(salary) AS average_salary
FROM employees e
JOIN departments d ON e.department_id=d.department_id
WHERE salary> (SELECT AVG(salary) FROM employees
WHERE department_id = d.department_id)
GROUP BY department_name
HAVING COUNT(*)>2
ORDER BY average_salary DESC;