WHERE Before GROUP BY

How can we analyze active employees by department?

Intermediate⏱ 3 Minutes⭐ 880 XP

🤔 THE QUESTION

How can we analyze active employees by department?

💡 WHAT IS IT?

WHERE filters individual rows before grouping, reducing the dataset before GROUP BY executes.

🎯 WHAT IS IT USED FOR?

Active-only headcount tracking, valid transaction summaries, active subscription counts.

💻 EXAMPLE

SELECT department, COUNT(*) AS active_employees
FROM employees
WHERE status = 'Active'
GROUP BY department;

Practice typing production-grade SQL code for WHERE Before GROUP BY.