Loading...
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
- mid
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.
Practice This Problem
Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.