Loading interview...

Content Mix

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

Domain
SQL
Difficulty
easy

Interview Prompt

The editorial team is deciding next quarter's production budget and wants to compare content formats head-to-head. For each content type, show the number of published items, the average duration in seconds, and the share of items that have no duration on file. Round the share to one decimal place and present the formats from most published 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