Rollback Roulette

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

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

The platform team is auditing release stability for the payment-api service before its next on-call rotation. Deployment outcomes are logged in deploy_logs, but the status column was populated by several different CI tools over the years, so the same outcome appears in mixed casing (for example 'FAILED' and 'failed'). Count how many deployments of the service named 'payment-api' ended with a failed status. Treat status values case-insensitively so no failed deploy is missed.

Summary

Some ships sink before they leave the harbor.

Practice This Problem

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