SQL - GROUP BY and HAVING
Consider the table
employees with columns department and salary. What does this query return?SELECT department, AVG(salary) FROM employees GROUP BY department;