First Light
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
- L6
Interview Prompt
A repo's early days last until its first successful CI build. Using `repo_commits` and the build history in `ci_builds`, report each author's average lines added and average lines removed per commit over the commits from those early days, biggest contributions first.
Summary
Every repo has a scrappy stretch before its first green build. See who was shipping then, and how big their changes were.
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