Average Review Comments by Author

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

Domain

SQL

Difficulty

medium

Seniority

L3

Problem

Engineering leadership is comparing review burden against tenure, treating each author handle as a case-sensitive identifier that must be matched exactly as it is stored. For every author who shows up in both the review log and the commit history, return the average number of comments across their code reviews alongside the date of their first commit. Present the authors starting from the longest-tenured (earliest first commit) down to the newest.

Summary

Some authors get more feedback than others.

Practice This Problem

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