Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Top Products by Category Monthly

Hard
SQL & Data ManipulationWindow FunctionsRankingsql

Problem

Given a database of customer transactions and product inventory, write a SQL query using window functions to find the top three selling products in each category per month.

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
Next questions
RAMP Consulting GroupTop Products Per CategoryMediumHarnhamWindow Functions for Top CategoriesMediumTop Product Categories by MonthMedium