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

Domain

SQL

Difficulty

medium

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.