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

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

The content team wants to see how each item compares to the longest piece in the catalog. Return all content items with their full details, duration as a decimal, and the difference in seconds from the longest item, listed from longest to shortest.

Summary

The catalog, sorted by length.

Practice This Problem

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