Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Top Spenders Per Region

Medium
MediumSQL & Data ManipulationWindow FunctionsDate FunctionsRankingAsked 1 times

Problem

Given a massive table of user transactions, write a query to find the top 3 highest-spending users in each region over the last 30 days.

Practicing as: Data Engineer interview at Ankercloud

Hi, I'll play your Ankercloud interviewer for the Data Engineer 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
Ankercloud Data Engineer Interview QuestionsAnkercloud Interview Questions
Next questions
PayPalTop Users by RegionMediumPhiladelphia StaffingTop Spenders Per Month QueryMediumFinacleTop Customers by SpendMedium