Find the average salary of each department.
sqlCopySELECT department, AVG(salary) AS average_salary FROM employees GROUP BY 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.