Loading interview...

2nd Most Common Content Type

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

Domain
SQL
Difficulty
hard
Seniority
mid, senior

Interview Prompt

The content platform team is analyzing what formats registered creators prefer. Only content from creators with a registered user account should be considered. Determine the second most popular content type by volume, and if multiple types tie for that rank, include all of them. Return the full content item records for every item belonging to the qualifying type or types.

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