Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Top Users by Region

Hard
HardSQL & Data ManipulationWindow FunctionsDate FunctionsRankingAsked 1 times

Problem

Write a SQL query to find the top 3 most active users in each region over the last 30 days.

Practicing as: Data Analyst interview at Andela Products

Hi, I'll play your Andela Products interviewer for the Data Analyst 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
AlteryxTop Active Users Per RegionHardAndela ProductsTop Active Users Per RegionHardGarminTop Users Per Region in 30 DaysMedium