Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

SQL Top Spenders by Month

Medium
MediumSQL & Data ManipulationWindow FunctionsRankingAggregationsAsked 1 times

Problem

Write an SQL query to find the top 3 users by total spend in each month.

Practicing as: Solutions Architect interview at ByteDance

Hi, I'll play your ByteDance interviewer for the Solutions Architect role. Candidates describe these interviews as mixed and moderately difficult, so expect me to be professional and fair. Take your time with the question above and answer like we're in the room.

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
ByteDance Solutions Architect Interview Questions
Next questions
Philadelphia StaffingTop Spenders Per Month QueryMediumCertiKTop 3 Users by Monthly SpendMediumSignifydTop Customers by Monthly SpendMedium