Service Scorecard
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
- L4
Interview Prompt
The VP of Engineering wants a single dashboard row per service tying deploys to alerts. For each service that deployed, report how many times it deployed and how many alerts fired for it, matched on service name.
Summary
Deploys vs. alerts. One row per service tells the whole story.
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