I am preparing for an upcoming job interview, and I am having difficulty with a SQL query question. I have been given the following code, but I am struggling to understand what it does and how to answer the related question:
ELECT AVG(salary)
FROM employees
GROUP BY department;
I would really appreciate any help or advice that could be offered to help me understand this code and how to answer the related query. Thank you!