A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

medium

Problem

The engineering analytics team is identifying the developer who most consistently lands big commits. Within 2025, group commits by month, then within each month rank them by lines added (largest first, no skipped ranks). For each author, count how many times they appear in a month's top ten across the year. Return the single author with the highest count, with ties broken alphabetically.

Summary

In a sea of commits, only a few wear the crown.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.