Loading interview...

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

Interview Prompt

The product team wants the top 5 content items by total page views. Match content items to page views by creator, and if items are tied in views, they should share the same rank (skipping subsequent ranks). Return items within the top 5 ranks, showing title and view count.

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