Latest Metric Values
An easy SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- L3
Interview Prompt
Our employee metrics table keeps several rows for the same department and metric name as values get revised over time, and the highest value is the one that counts as current. Return each department and metric name paired with its current value.
Summary
Stale records hiding in the metrics.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write and run your SQL against a real database
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision