Aggregate with Filter

How can we calculate the average salary only for engineers?

Intermediate⏱ 3 Minutes⭐ 810 XP

🤔 THE QUESTION

How can we calculate the average salary only for engineers?

💡 WHAT IS IT?

The WHERE clause restricts rows before aggregation functions are evaluated.

🎯 WHAT IS IT USED FOR?

Segmented averages, department KPIs, filtered spend analytics.

💻 EXAMPLE

SELECT AVG(salary) AS average_engineering_salary
FROM employees
WHERE department = 'Engineering';

Practice typing production-grade SQL code for Aggregate with Filter.