GROUP BY with AVG

How can we compare average salaries across departments?

Intermediate⏱ 3 Minutes⭐ 840 XP

🤔 THE QUESTION

How can we compare average salaries across departments?

💡 WHAT IS IT?

GROUP BY with AVG() computes the arithmetic mean for each group independently.

🎯 WHAT IS IT USED FOR?

Comparing departmental pay averages, analyzing product rating means.

💻 EXAMPLE

SELECT department, AVG(salary) AS average_salary
FROM employees
GROUP BY department;

Practice typing production-grade SQL code for GROUP BY with AVG.