Top Commit Authors by Repo
A hard 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
- hard
- Seniority
- L5
Interview Prompt
Our commit history feeds a per-repo contributor leaderboard, where an author's weight is the total lines they have added. For each repo, the developer-experience team wants its heaviest contributors laid across one row, heaviest first, each entry naming the author with their line total and their share of the lines added across the whole codebase.
Summary
Three authors per repo. The top committers.
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