Loading interview...

Content Session Counts

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
junior, mid

Interview Prompt

The content team wants to understand which pages drive the most session engagement. For each page URL, count how many unique sessions viewed it (deduplicated per page). Show all pages with their unique session count, sorted from most viewed to least.

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