The Apprentices Still in the Forge
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 ML platform team is sizing a new training GPU cluster and needs to know how much of the model catalog is still mid-flight. A model whose status is 'training' has not yet been validated or deployed and is still consuming training capacity. Count how many distinct model names (mdl_name) currently have a status of 'training'. Status values may arrive in mixed casing, so compare case-insensitively. Return the count as training_count.
Summary
A model is not a model until it stops learning and starts earning.
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