Find Department With Highest Salary Expenditure

Question

Find the department with the highest total salary expenditure.

Accepted Answer

```sql
SELECT department_name, SUM(salary) AS total_salary
FROM employees
GROUP BY department_name
ORDER BY total_salary DESC
LIMIT 1;
```

This query groups the "employees" table by "department_name", calculates the sum of "salary" for each group, and returns the department with the highest total expenditure.