Loading interview...

Biggest Deployment Decline

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
mid

Interview Prompt

A downstream report flagged a drop in one service's deploy frequency. Find which service had the biggest month-over-month drop in deployments from March to April 2026. Only include services that also appear in svc_health. Return just the service with the largest decline, showing the service name and the size of the decline.

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