Deploy Author Performance Score

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

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

The platform team wants a reliability scorecard for everyone who has shipped deploys, treating author names that differ only in capitalization as the same person. Score each author as (100 minus their average deploy duration) multiplied by their number of deploys, counting only deploys from the most recent calendar year present in the log and the year before it. Return each author with their average duration and score (both rounded to two decimals) plus their standing from the strongest score to the weakest.

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.