Average Review Comments by Author
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
- L3
Interview Prompt
Engineering leadership is comparing review burden against tenure. For every author who shows up in both the review log and the commit history, return the average number of comments across their code reviews alongside the date of their first commit.
Summary
Some authors get more feedback than others.
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