Question

Write an Oracle SQL query to find the average salary of employees within each department.

Answer 1

SELECT department_id, AVG(salary) AS average_salary

FROM employees

GROUP BY department_id;