Top-Ranked Wines by Variety

A easy SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

easy

Problem

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.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.