GROUP BY Multiple Columns

How can we analyze employee counts by department and job title?

Intermediate⏱ 3 Minutes⭐ 850 XP

🤔 THE QUESTION

How can we analyze employee counts by department and job title?

💡 WHAT IS IT?

Grouping by multiple columns forms sub-groups based on unique combinations of all specified fields.

🎯 WHAT IS IT USED FOR?

Role breakdowns per department, regional product sales matrices, multi-dimensional reporting.

💻 EXAMPLE

SELECT department, job_title, COUNT(*) AS employee_count
FROM employees
GROUP BY department, job_title;

Practice typing production-grade SQL code for GROUP BY Multiple Columns.