Busy Authors

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

An engineering manager is spotlighting the most prolific contributors, counting only commits whose message was actually recorded. For each author with 24 or more of those commits, show their commit total and how many repositories they've touched.

Summary

Some developers spread their commits everywhere.

How This Interview Works

1. Read the vague prompt (just like a real interview)
2. Ask clarifying questions to the AI interviewer
3. Write and run your SQL against a real database
4. Answer the interviewer's follow-up questions, then get a hire or no-hire decision