Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Monthly Transaction Aggregations

Easy
EasySQL & Data ManipulationDate FunctionsGroup ByAggregations

Problem

How would you write a query to aggregate customer transactions by month and segment?

Practicing as: Marketing Analytics Specialist interview at dunnhumby

Hi, I'll play your dunnhumby interviewer for the Marketing Analytics Specialist 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
HsbcMonthly Customer Transaction SummaryMediumFifth Third BankAggregate Monthly Transaction DataMediumConsumer EdgeSQL Monthly Transaction AggregationMedium