Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Top Suppliers by Category

Medium
SQL & Data ManipulationWindow FunctionsRankingAggregations

Problem

Write a SQL query using window functions to identify the top three suppliers by transaction volume for each product category.

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
Top Products by Category MonthlyHardHarnhamWindow Functions for Top CategoriesMediumMeeshoTop Products Per CategoryMedium