Average Headcount by Department

A easy SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.

Domain

SQL

Difficulty

easy

Seniority

L3

Interview Prompt

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.

Summary

Compensation benchmarks, department by department.

How This Interview Works

1. Read the vague prompt (just like a real interview)
2. Ask clarifying questions to the AI interviewer
3. Write your sql solution with real code execution
4. Get instant feedback and a hire/no-hire decision