FreePro125 ProblemsSQL + Python
Streaming Media SQL & Python Interview Questions
Streaming platforms optimize content recommendations, analyze viewing behavior, and track subscription retention. These SQL and Python challenges are modeled after work at Netflix, Spotify, YouTube, Disney+, Max, Apple TV+, Amazon Prime Video, Paramount+, Twitch, Tidal, and more. Practice watch time analysis, content completion rates, content ROI, catalog performance, and subscriber churn modeling.
Companies working in Streaming Media
These practice problems are modeled after the kind of data and analytics challenges teams in this industry typically face.
Company names and logos are trademarks of their respective owners, used here only to describe the kind of data these companies work with. Let's Data Science is not affiliated with, endorsed by, or sponsored by any company shown. Practice problems are original works and are not real interview questions from these companies. Rights & takedowns.
Difficulty Distribution
Easy
25
20% of problems
Medium
48
38% of problems
Hard
44
35% of problems
Expert
8
6% of problems
What You'll Practice
Watch time analysis
Content completion rates
Subscription retention
Recommendation signal metrics
Content ROI analysis
User engagement metrics
Binge-watching patterns
Audio & video performance
Topics Covered
SQL· 9
aggregationbasic queries filteringcleaning transformdate timejoinsscenario sqlset operationssubqueries cteswindow functions
Python· 12
eda statisticsfeature engineeringpandas aggregationpandas applypandas basicspandas cleaningpandas datetimepandas filteringpandas mergingpandas reshapingpandas scenariopandas window
All Problems125 total
01
Active Action MoviesFree
SQLEasy02Long Completed UHD/4K SessionsFree
SQLMedium03Active Subscribers With Recent UHD/4K ActivityFree
SQLHard04Latest Playback Session per UserFree
SQLMedium05Latest Active Subscription per UserFree
SQLMedium06Highest-Priced Active Plan per RegionFree
SQLMedium07Top 3 Longest Sessions per User — Last 120 DaysFree
SQLHard08Region Revenue Ranking — Last 90 DaysFree
SQLHard09Streaming Payments by Most Recent TimeFree
SQLEasy10Sessions Started in the Device’s Registration MonthFree
SQLMedium11Normalize Streaming User LocalesFree
SQLMedium12Completed Playback Sessions (Normalized)Free
SQLMedium13Active Originals in a Specific GenreFree
SQLEasy14Active Users With Single DeviceFree
SQLMedium15Latest qualifying session per device for active subscribersFree
SQLHard16Filter Users by CountryFree
PYTHONEasy17Filter North American Active UsersFree
PYTHONHard18Filter US SubscribersFree
PYTHONEasy19Filter Users from Multiple CountriesFree
PYTHONMedium20Count Users by CountryFree
PYTHONEasy21Unique Countries by Account StatusFree
PYTHONMedium22Melt Plan PricingFree
PYTHONEasy23Pivot Payments by Method and StatusFree
PYTHONMedium24Pivot Playback by Device and QualityFree
PYTHONHard25Rolling Average Watch TimeFree
PYTHONEasy26Calculate Payment ChangeFree
PYTHONMedium27Rolling Average per UserFree
PYTHONHard28Filter Subscriptions by Date RangeFree
PYTHONEasy29Aggregate Payments by MonthFree
PYTHONMedium30Weekend vs Weekday Playback AnalysisFree
PYTHONMedium31Replace Status CodesFree
PYTHONMedium32Clean Subscription Analytics DataFree
PYTHONHard33Map Status to LabelsFree
PYTHONEasy34Session Quality AnalysisFree
PYTHONHard35Viewer Activity SummaryFree
PYTHONMedium36Active Users in Target CountriesPro
SQLEasy37Original Movies in CatalogPro
SQLEasy38Failed Subscription PaymentsPro
SQLEasy39High-Rated Titles with ReviewsPro
SQLMedium40Long Completed Playback SessionsPro
SQLMedium41Active Subscriptions with Plan DetailsPro
SQLEasy42Completed Playback with User and TitlePro
SQLMedium43Captured Payments with User and PlanPro
SQLMedium44High Ratings with User and TitlePro
SQLMedium45Titles Never WatchedPro
SQLHard46Watchers Who Never RatedPro
SQLHard47Playback Session Count by StatusPro
SQLEasy48Average Rating by GenrePro
SQLMedium49Total Watch Time Per UserPro
SQLMedium50Users With Multiple Devices Per TypePro
SQLMedium51Top Five Most-Watched TitlesPro
SQLHard52Revenue by Plan Type With Refund RatePro
SQLHard53Rank Titles by Total Watch TimePro
SQLMedium54Number Each User's Playback SessionsPro
SQLMedium55Running Total of Daily PaymentsPro
SQLHard56Top Title per Genre by RatingPro
SQLHard57Monthly Watch Hours Moving AveragePro
SQLHard58Payment Amount Change from PreviousPro
SQLHard59User Watch Time Quartile AnalysisPro
SQLHard60Titles Rated Above AveragePro
SQLMedium61Users Who Watched and Rated the Same TitlePro
SQLHard62Most Recent Subscription per UserPro
SQLHard63Watchlisted but Never WatchedPro
SQLHard64Content Engagement ScorecardPro
SQLExpert65Users Signed Up in 2024Pro
SQLEasy66Monthly Playback Session VolumePro
SQLMedium67Average Subscription Duration by StatusPro
SQLMedium68User Tenure vs Watch ActivityPro
SQLHard69Playback Quality Tier LabelsPro
SQLEasy70User Engagement Tier ClassificationPro
SQLMedium71Content Maturity Risk ReportPro
SQLHard72Titles Watched or RatedPro
SQLMedium73Former Subscribers with PaymentsPro
SQLMedium74Content Performance ScorecardPro
SQLHard75User Churn Risk AssessmentPro
SQLHard76Device Platform AnalyticsPro
SQLHard77Payment Health DashboardPro
SQLHard78Subscriber Lifetime Value ReportPro
SQLExpert79Content Catalog Health AnalysisPro
SQLExpert80Streaming Platform User DashboardPro
SQLExpert81Active User ProfilesPro
PYTHONEasy82Content Type CountsPro
PYTHONEasy83Device Type SummaryPro
PYTHONMedium84Plan Quality OverviewPro
PYTHONMedium85Active Auto-Renewing SubscriptionsPro
PYTHONEasy86Recent Active Original TitlesPro
PYTHONEasy87Long Playback SessionsPro
PYTHONMedium88Failed Payments Since July 2024Pro
PYTHONMedium89Sessions by StatusPro
PYTHONEasy90Total Watch Time by DevicePro
PYTHONMedium91Average Rating by GenrePro
PYTHONMedium92Payment Stats by ProcessorPro
PYTHONHard93User Engagement SummaryPro
PYTHONHard94Subscriptions with Plan NamesPro
PYTHONEasy95Average Rating per TitlePro
PYTHONMedium96Titles Not in Any WatchlistPro
PYTHONMedium97Enriched Movie Playback LogPro
PYTHONHard98Session Full HierarchyPro
PYTHONHard99Rank Users by Watch TimePro
PYTHONMedium100Cumulative Payments Per UserPro
PYTHONMedium101Seven-Day Rolling Watch TimePro
PYTHONHard102Daily Session ChangePro
PYTHONHard103Subscription Start Month and YearPro
PYTHONEasy104Subscription Duration in DaysPro
PYTHONMedium105Monthly Session Volume and Watch HoursPro
PYTHONHard106Fill Missing Subscription End DatesPro
PYTHONEasy107Normalize Payment Amounts to USDPro
PYTHONMedium108Standardize Device OS into Platform CategoriesPro
PYTHONHard109Pivot Sessions by QualityPro
PYTHONMedium110Pivot Rating Distribution by GenrePro
PYTHONHard111Classify Titles by MaturityPro
PYTHONMedium112Session Engagement ScorePro
PYTHONHard113Compute Session Completion RatePro
PYTHONMedium114Watch-Time Quartile BucketingPro
PYTHONHard115Time-Based Session FeaturesPro
PYTHONHard116User Feature MatrixPro
PYTHONExpert117Title Engagement FeaturesPro
PYTHONHard118Payment Amount Descriptive StatsPro
PYTHONMedium119Watch Time vs Rating CorrelationPro
PYTHONHard120Anomalous Watch Time DetectionPro
PYTHONHard121Content Performance ScorecardPro
PYTHONHard122Subscriber Churn Risk ReportPro
PYTHONHard123Content Recommendation PipelinePro
PYTHONExpert124Subscriber Health ClassificationPro
PYTHONExpert125Cross-Device Viewing AnalysisPro
PYTHONExpertReady to practice Streaming Media?
125 SQL and Python challenges built from real streaming media data. Graded instantly in your browser — no setup required.