Employees Per Department

A easy SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

easy

Seniority

L5

Problem

Surface the employee count per department, ranked from largest to smallest. For ties, use alphabetical department name so the output is deterministic.

Summary

Headcount, location by location.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.