<prompt> Kutokana na meza ya mshahara wa wafanyakazi na safu EmployeeID, Salary, na Idara ID, kuandika SQL query kupata wastani wa mshahara kwa kila idara.  <response>: The SQL query to find the average salary for each department would be:SELECT DepartmentID, AVGSalary AS AverageSalaryFROM employeeGROUP BY DepartmentIDThis will group the salaries by department and then calculate the average salary for each group. The result will be a table with two columns: DepartmentID and AverageSalary. 