Top Content by Views

A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.

Domain

SQL

Difficulty

medium

Seniority

L4

Interview Prompt

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.

How This Interview Works

1. Read the vague prompt (just like a real interview)
2. Ask clarifying questions to the AI interviewer
3. Write your sql solution with real code execution
4. Get instant feedback and a hire/no-hire decision