Both Ends of the Pipe
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
- L4
Interview Prompt
The release engineering team wants the authors who carry a build all the way from dev into production, treating the same environment name in different casing as one. List each qualifying author with how many of those two environments they deployed to, alphabetically.
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 your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision