Message Length

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

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

The engineering manager believes that longer commit messages correlate with riskier changes and wants data to back it up. For each author, show the average commit message length, the total number of commits, and the average lines of code added per commit. Skip any commits that have no message. Only include authors with more than two commits, listed from longest average message to shortest.

Summary

Verbose commits. Risky changes?

Practice This Problem

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