Consider the tables: Employee(emp_id, name, dept_id, salary) and Department(dept_id, dept_name). Which SQL query correctly finds the department name with the highest average salary?
-
A
SELECT dept_name FROM Department d JOIN Employee e ON d.dept_id = e.dept_id GROUP BY dept_name HAVING AVG(salary) = (SELECT MAX(AVG(salary)) FROM Employee GROUP BY dept_id)
-
B
SELECT dept_name FROM Department d JOIN Employee e ON d.dept_id = e.dept_id GROUP BY dept_name ORDER BY AVG(salary) DESC LIMIT 1
-
C
SELECT dept_name, MAX(salary) FROM Department d JOIN Employee e ON d.dept_id = e.dept_id
-
D
SELECT dept_name FROM Department WHERE salary = MAX(salary)