company sql set
Netflix
Netflix
SQL Set
Streaming analytics for watch time, churn, ratings, content popularity, genres, and user behavior.
question list
Work through all 10 questions
Open a problem, write the query, check the expected output, then come back for the next rep.
Q01
Identify VIP Users
Segment users by viewing behavior.
Q02
Monthly Show Rating
Aggregate show ratings by month.
Q03
Binge Watchers
Find users with binge behavior.
Q04
Churn Risk Users
Detect users at risk of churn.
Q05
Most Watched Show
Rank shows by total watch activity.
Q06
Genre Popularity
Measure popularity by genre.
Q07
Top Rated Content
Find highest-rated content.
Q08
Daily Active Users
Count daily unique viewers.
Q09
Multi-Genre Users
Find users watching multiple genres.
Q10
First Content Watched
Use ranking to get first watched item.