Write a SQL query to find the average salary of employees in each department from tables 'employees' and 'departments'.

 SELECT d.department_name, AVG(e.salary) AS average_salary

FROM employees e

INNER JOIN departments d ON e.department_id = d.department_id

GROUP BY d.department_name;