Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Top Categories by Month SQL

Medium
SQL & Data ManipulationWindow FunctionsRankingAggregations

Problem

Given a set of records, write a SQL query to find the top 3 categories by total sales for each 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
The Clorox Software Engineer Interview QuestionsThe Clorox Interview Questions
Next questions
AritziaTop 3 Products Per CategoryMediumRAMP Consulting GroupTop Products Per CategoryMediumStubhubTop Categories by MonthMedium
0 / ~200 words