Loading...

Average Headcount by Department

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

Domain
SQL
Difficulty
easy
Seniority
junior

Problem

The VP of Engineering asked HR for a quick staffing snapshot before the reorg meeting. From the employee metrics, isolate the headcount records and compute the average headcount value per department.

Practice This Problem

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