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

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

Rate each deploy author over the past 12 months using the formula (100 minus average duration) times number of deploys. Round the score and average duration to 2 decimal places. Show each author with their average duration, score, and rank, sorted from highest score to lowest.

Summary

Not all deployers are equally reliable.

Practice This Problem

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