Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

SQL: Average Amount for Recent Signups

Easy
SQL & Data ManipulationDate FunctionsJoinsAggregations

Problem

Given a table of transactions and a table of user profiles, join them to find the average transaction amount for users who signed up in the last 90 days.

Practicing as: Risk Analyst interview at Chime

Hi, I'll play your Chime interviewer for the Risk Analyst 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.

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
Chime Risk Analyst Interview Questions
Next questions
xAISQL Average Transaction Per CustomerEasyLendbuzzRolling 3-Day Transaction AverageMediumSoFiRolling 30-Day Transaction AverageMedium