SELECT d.department_name, AVG(e.salary) AS average_salary, COUNT(e.employee_id) AS number_of employee FROM departments d LEFT JOIN employees e ON d.department_id = e.department_id GROUP BY d.department_id, d.department_name;
