Both Ends of the Pipe
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
- L4
Interview Prompt
A release manager is auditing `deploy_logs` for authors whose deploys span at least two of the three standing environments: dev, staging and production. Return each qualifying author with how many of those environments they reached.
Summary
Dev and prod, both touched by the same hand. Who are they?
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