Message Length

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

Domain

SQL

Difficulty

easy

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.

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.