The Longest Take

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

Domain

SQL

Difficulty

easy

Seniority

L4

Problem

A media platform's 2026 retrospective spotlights the longest piece in each content format, drawn from everything published since 2026. Return the content items whose runtime is the longest ever recorded for their format, with their unique content IDs and titles.

Summary

The content that held the number-one spot.

Practice This Problem

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