Service Uptime Turnaround
A hard SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- hard
- Seniority
- L5
Interview Prompt
Find services that experienced at least one month of declining uptime followed by at least one month of growth. For each qualifying service, return the service name, the month the decline started, the month growth resumed, and the growth ratio from lowest uptime to peak: (peak minus lowest) divided by lowest.
Summary
It was down. Then it came back. Stronger.
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