Radio Silence

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

Domain

SQL

Difficulty

hard

Seniority

L5

Problem

An engineering manager is auditing repositories that have gone quiet, where a repository's longest silence is the widest stretch of days between two back-to-back commits. Commit timestamps are stored as text and the queries run on SQLite, so the day count has to come out of the stored timestamps. Surface the repositories whose longest silence runs past 5 days, ordered from the most silent down, and number the standings as you go.

Summary

Some codebases stop speaking for too long.

Practice This Problem

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