Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Top Categories Per User

Medium
SQL & Data ManipulationWindow FunctionsDate FunctionsRanking
Asked 2mo ago|
Roku
Roku

Problem

Write a SQL query using window functions to identify the top three most-watched content categories for each Roku user over the last 30 days.

You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.

Sign up freeI have an account
Sign up to unlock solutions
Roku Data Engineer Interview Questions
Next questions
RokuTop Genres by DemographicMediumRokuRank Users by Weekly HoursMediumTubiTop Genres With SQL WindowsHard
0 / ~200 words