What Set It Off
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
- L4
Interview Prompt
A CI platform's reliability team wants to see how build activity breaks down by what kicked each build off. For each trigger type, show how many builds it produced and the average build duration in seconds, listed alphabetically by trigger.
Summary
Every build has a cause. Tally the work behind each one.
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