Build Health

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

Domain

SQL

Difficulty

medium

Problem

The platform team is preparing a CI health report for the engineering all-hands. For each repository, show the number of builds that finished successfully, the number that failed, and the success rate as a percentage of all builds. Only include repositories that have run at least three builds total , anything with fewer runs isn't meaningful. Present from highest success rate to lowest.

Practice This Problem

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