Loading interview...

Top-Ranked Wines by Variety

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

For user 197, compute AVG(session_duration_sec) from user_sessions. Return three columns: the literal value 197 as user_id, content_id, and duration_seconds, for every content_items row whose duration_seconds is less than or equal to that average.

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