Fresh Ink

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

Domain

SQL

Difficulty

medium

Seniority

L3

Problem

We keep a table of repository commits, each stamped with its author and commit date. Counting only commits from the three most recent calendar years present in the data (the year of the latest commit and the two years before it), find the ten authors with the most commits. Return each author with their commit count, most active first.

Summary

Recent activity is the only activity that counts. Name the busiest hands.

Practice This Problem

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