Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

SQL Rank Top Users by Region

Hard
HardSQL & Data ManipulationWindow FunctionsJoinsRanking

Problem

Write a SQL query using window functions to rank users by revenue within each region and return the top 3 per region.

Practicing as: Data Scientist interview at Fanning Personnel

Hi, I'll play your Fanning Personnel interviewer for the Data Scientist role. Answer the question above like we're in the room, and I'll respond the way a real interviewer would.

Take this as a live interview session →

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
Fanning Personnel Data Scientist Interview QuestionsFanning Personnel Interview Questions
Next questions
Kpmg UsSQL Window Ranking by RegionMediumEverCRank Users by RevenueHardClaritevSQL Window Ranking QueryHard