SQL With Constraints and Joins | Dataford Interview Questions

Netflix wants to compare engagement across movie genres using viewing-session data. Write a PostgreSQL query that joins viewing sessions to title metadata and calculates the average watch time for qualifying sessions.

Requirements

Join viewing_sessions to titles using title_id.
Include only completed movie sessions from calendar year 2025 with at least 10 minutes watched.
Return each genre, the number of qualifying sessions, and the average minutes watched, rounded to two decimal places.
Keep only genres with at least two qualifying sessions and order by average watch time from highest to lowest.

Schema

titles

Column	Type	Description
title_idPK	INTEGER	Unique Netflix title identifier
title_name	VARCHAR(150)	Name of the title
genre	VARCHAR(50)	Primary title genre
content_type	VARCHAR(20)	Whether the title is a Movie or Series

viewing_sessions

Column	Type	Description
session_idPK	INTEGER	Unique viewing session identifier
title_id	INTEGER	References titles.title_id
profile_id	INTEGER	Netflix profile identifier
watched_at	DATE	Date of the viewing session
minutes_watched	NUMERIC(8,2)	Minutes watched during the session
session_status	VARCHAR(20)	Session completion status

Your question is SQL With Constraints and Joins. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem