Write an SQL query to find the average salary for each department in the employees table.

sql SELECT department_id, AVG(salary) AS average_salary FROM employees GROUP BY department_id ORDER BY department_id;

This query groups employees by departments (`department_id`) and calculates the average salary (`AVG(salary)`) for each department. The result is sorted by department ID for convenience.