Zero-Retry Job Ratio by Priority

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

Domain

SQL

Difficulty

hard

Seniority

L4

Problem

The batch processing system tracks retry counts per job. Calculate the ratio of jobs that completed without any retries to total jobs, broken down by priority level. A zero-retry job has retries equal to 0. Show the priority, count of zero-retry jobs, total jobs for that priority, and the ratio, from lowest ratio to highest.

Summary

No retries needed. First try success rate.

Practice This Problem

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