Heavy Hitters

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

Domain

SQL

Difficulty

medium

Seniority

L3

Problem

The eng director wants to spot repos with higher-than-average activity. Count commits per repo in repo_commits, compare against the overall average commits per repo across the table, and keep repos that exceed it. Return the repo_name and its commit count.

Summary

Some repos never sleep.

Practice This Problem

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