Top-Ranked Wines by Variety

An easy SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.

Domain

SQL

Difficulty

easy

Seniority

L3

Interview Prompt

The product team is looking at content that runs shorter than user 197's average session length. Return those content items, showing the literal user ID 197, the content ID, and the duration in seconds.

Summary

The best bottles. Ranked by variety.

How This Interview Works

1. Read the vague prompt (just like a real interview)
2. Ask clarifying questions to the AI interviewer
3. Write and run your SQL against a real database
4. Answer the interviewer's follow-up questions, then get a hire or no-hire decision