Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Top Failed Payments in Rolling Window

Hard
SQL & Data ManipulationWindow FunctionsRankingsqlAsked 1 times

Problem

Write a SQL query to find the top 5 user accounts with the highest number of failed payment attempts within a rolling 10-minute window at Affirm.

Practicing as: Risk Analyst interview at Affirm

Hi, I'll play your Affirm 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
Affirm Risk Analyst Interview Questions
Next questions
FinSQL for High-Value Rolling WindowHardChimeSQL: Failed Transactions in WindowMediumPhonepeTop Failed Users YesterdayMedium