Build Health

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

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

The platform team wants a CI health leaderboard for the all-hands, scoring each repository in `ci_builds` by its success rate. Measure that rate against every build a repo ran, not only the ones that ended in success or failure, and leave out repos with too few builds to be meaningful. Show the healthiest repos first.

Summary

Score every repo by how often CI stays green.

Practice This Problem

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