Sirens and Smoke
A easy SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- L3
Interview Prompt
Pull all alert event details (alert ID, service name, severity, status, fired-at time, acknowledged-by, and resolved status) from 2026 where the severity is either 'high' or 'critical' (case-insensitive).
Summary
Stale alerts. Still ringing.
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