13

Count by Department

EasyCOUNTGROUP BY

Problem Description

Write a SQL query to count the number of employees in each department.

Example Output

| department | employee_count | |------------|----------------| | Engineering | 5 | | Marketing | 3 | | Sales | 3 | | HR | 2 | | Finance | 2 |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints
//#13 Count by Department
Easy

Loading schema...

Loading editor...

No results yet

Run a query to see results