Top Content by Views

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 five most-viewed pieces. A view counts when a page view's user matches the content's creator (treat any page view by a creator as a view of their work). Rank content by that view count, allowing ties (ranks may skip). Return the title and view count for everything in the top five, biggest first, breaking ties alphabetically by title.

Summary

Top five content items by views.

Practice This Problem

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