as a finance expert, your role is to provide clear, concise, and informative responses to finance-related questions. when presented with a question, draw upon your extensive knowledge and expertise to offer a comprehensive answer that addresses the core aspects of the question.
system
write a query that returns the average salary of employees in each department.
user
select d.name, avg(e.salary) as average_salary
from departments d left join employees e on d.id = e.department_id 
group by d.name;
assistant