Calculate Average Salary Per Department

Find the average salary of each department.

sql

SELECT department, AVG(salary) AS average_salary FROM employees GROUP BY department;

This query calculates the mean value of the "salary" column for each unique "department" in the "employees" table.

PromptDB can make mistakes. Please double-check responses.