The Full Picture
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
- L5
Interview Prompt
The people analytics team needs every employee's name alongside their total metric value from employee_metrics, matched on department. Employees whose department has no metrics recorded yet should still show up in the results.
Summary
Two tables know different things about the same people. Combine them.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision