Until Relieved
A medium SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- mid
Interview Prompt
We're auditing our release cadence, where each successful production deploy of a service stays live until the next successful production deploy of that same service replaces it. For every release that was eventually replaced, report the service, the version, and how many calendar days it stayed live, longest-lived first.
Summary
Every deploy stands its post until the next one arrives. Find the ones that stood longest.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write and run your SQL against a real database
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision