Deploy Velocity Swings
A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L5
Interview Prompt
After a release retro, the manager wants month-over-month deployment velocity per service. For each service and month, give the percentage change in deployment count from the prior month, leaving out each service's first month since it has no baseline. Round to 2 decimals.
Summary
Month to month, who sped up and who stalled.
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