Early Commit Velocity by Author

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

Domain

SQL

Difficulty

medium

Seniority

L6

Problem

Engineering management is studying contributor patterns during the first year of every repo's life on CI. The clock starts at a repo's very first CI build and runs for one year. For each author who committed inside that window, report the typical size of their commits (average lines added) and how long after the first build their commits typically landed.

Summary

How productive was each author during the first year of a repo's CI pipeline

Practice This Problem

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