Loading interview...

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
senior, staff

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.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your sql solution with real code execution
  4. Get instant feedback and a hire/no-hire decision