Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
At Netflix, each time a user watches a video, the event is recorded with the user's ID, the video's ID, and the date and time of the watch.
The dataset is stored in a table named user_video_watch, which has the following columns:
Your goal is to find the top 3 videos that have been most frequently watched as one of the first 2 videos by new users on the platform.
The output should list the video_id and the count of how many times it was among a user's first 2 watches. In case of ties where multiple videos have the same count in the top 3, include them all in the results.
At Netflix, each time a user watches a video, the event is recorded with the user's ID, the video's ID, and the date and time of the watch.
The dataset is stored in a table named user_video_watch, which has the following columns:
Your goal is to find the top 3 videos that have been most frequently watched as one of the first 2 videos by new users on the platform.
The output should list the video_id and the count of how many times it was among a user's first 2 watches. In case of ties where multiple videos have the same count in the top 3, include them all in the results.