The Weight of Words

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

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

An engineering manager wants to test a hunch that authors who write longer commit messages tend to ship riskier changes. For each author, find the average commit message length, the number of commits, and the average lines added per commit, ignoring commits that have no message. Keep only authors with more than two commits, longest average message first.

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.