The Roster

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

Domain

SQL

Difficulty

easy

Seniority

L5

Problem

We need a headcount breakdown by department, from the biggest teams down to the smallest. When two departments have the same headcount, list them in alphabetical order.

Summary

Every department, counted head by head.

Practice This Problem

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