Average Build Duration by Repo

An easy 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
easy
Seniority
L3

Interview Prompt

Slow builds are blocking deploys and the CI/CD team suspects a few repos are dragging down the pipeline. Show the average build duration in seconds for each repository so they can spot the worst offenders.

Summary

Some repos build fast. Others don't.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write and run your SQL against a real database
  4. Answer the interviewer's follow-up questions, then get a hire or no-hire decision