Repository Commit Ranking
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
- L4
Interview Prompt
We're publishing repository standings from our commit history. For each repository, total the lines added across its commits and produce the leaderboard from most to fewest, showing the repo name, its total lines added, and its rank.
Summary
Lines added tell the story of a repo's ambition.
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