Daily Metric Percentage Change
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 deploy incident, the release manager wants to see day-over-day deployment velocity changes per service. For each service and deploy date, compute the percentage change in deployment count from the previous day. Exclude the first day for each service since there's no baseline. Round to 2 decimal places.
Summary
Yesterday versus today. What moved?
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