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

staff

Problem

For every repo, define the early period as the first year after that repo's earliest CI build. For each author who committed during that window, surface their average lines added per commit and the average number of days after the first build that their commits landed.

Practice This Problem

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