Question

Imagine you’re an HR manager and want to get an overview of the average performance rating for each department. Write an Oracle SQL query to retrieve the department and the average performance rating for each department.

Answer 1

SELECT department, AVG(rating) AS avg_rating

FROM employees

GROUP BY department;