Calculating Average Salary per Department Using a Cursor

Problem

Write a cursor that will iterate over a table of employees and calculate the average salary for each department.
Example input:
DEPARTMENT_ID | SALARY
1 | 30000
2 | 40000
3 | 50000
Example output:
DEPARTMENT_ID | AVERAGE_SALARY
1 | 30000
2 | 40000
3 | 50000

Solution

This solution is in SQL. Our A.I. can create solutions in multiple languages.

sarastevens

/*

SELECT DEPARTMENT_ID, AVG(SALARY)
FROM EMPLOYEES
GROUP BY DEPARTMENT_ID;

This is optimal because it uses a single query to calculate the average salary for each department.

*/