The Weight of Words
A easy SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- L3
Interview Prompt
An engineering manager wants to test a hunch that authors who write longer commit messages tend to ship riskier changes. For each author, find the average commit message length, the number of commits, and the average lines added per commit, ignoring commits that have no message. Keep only authors with more than two commits, longest average message first.
Summary
Verbose commits. Risky changes?
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision