Top Content by Lifetime Value

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 content team wants the most-watched content overall. A view counts toward a piece of content when a page view's user matches that content's creator (treat any page view by a creator as a view of all their work). Sum the page view durations to get each content item's lifetime value. Rank by lifetime value descending, allowing ties to share a rank. Return the top three ranks, with content ID, title, and lifetime value.

Summary

Lifetime value. Measured in total watch time.

Practice This Problem

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