Count by Department
Easy
group-by
Write a query to count the number of employees in each department.
Return columns department and employee_count, ordered by
employee_count descending, then by department ascending.
Tables
Hints (2 available)
SQL Editor
Output
Click "Run" to see results...