First Movie Stream per User | Dataford Interview Questions

Using the same STREAMS/TITLES tables, find the name and title id of the first movie streamed by each user each day.

Asked in the phone screen stage.

Output

Return one row per user and calendar day with columns user_id, stream_date, name, and title_id.
Include only the earliest valid movie stream for each user and day. Ignore streams without a timestamp or matching title.
Order by user_id, then stream_date, both ascending. Break timestamp ties with the lowest stream_id.

streams

Column	Type	Description
stream_idPK	INT	Unique stream event identifier
user_id	INT	Identifier of the user who streamed the movie
stream_timestamp	TIMESTAMPTZ	Timestamp when the movie stream began
title_id	INT	Movie identifier referenced in titles

titles

Column	Type	Description
title_idPK	INT	Unique movie identifier
name	VARCHAR(150)	Movie title name

Your question is First Movie Stream per User. 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.