Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Top Active Users Per Region

Hard
HardSQL & Data ManipulationWindow FunctionsJoinsAggregations

Problem

Write a SQL query to find the top three most active users per region over the last 30 days, given tables containing user events and account details.

Practicing as: Data Engineer interview at Alteryx

Hi, I'll play your Alteryx 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
Next questions
Andela ProductsTop Users by RegionHardAndela ProductsTop Active Users Per RegionHardGarminTop Users Per Region in 30 DaysMedium