Quiet Failures

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

Domain

SQL

Difficulty

medium

Seniority

mid

Problem

A payments platform's release team is auditing how reliably each service ships to production, where the deploy log records that environment inconsistently as both 'Production' and 'production'. For each service with at least three production deployments, report its total deployments, how many carried a 'success' status, and the resulting success rate, least reliable first.

Summary

Some services land every release; others only look like they do. Find the ones production can't count on.

Practice This Problem

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