Search ⌘K
Stripe
Stripe

Interview Core Track · Hard · 35 min

Rapid Repeat Card Payments

Risk operations wants to flag merchants that received back-to-back payments for the same amount within a ten-minute window. For each merchant_id, return repe...

Interview Core Track
Hard
35 min
query basics
filtering
date functions

Company labels are directional practice context, not official interview guidance.

Timer 00:00
Back to practice

Objective

Practice query basics through a Stripe-tagged business scenario.

Approach

Use this track to improve speed, edge-case handling, and accuracy under timed conditions.

Company context

Company labels are directional practice context, not official interview guidance.

Prereq: query basics
Prereq: filtering

Risk operations wants to flag merchants that received back-to-back payments for the same amount within a ten-minute window. For each merchant_id, return repeated_payment_count ordered by merchant_id.

Pro question
This is a Pro question

Upgrade to Pro to unlock this prompt, the SQL workspace, and all 254 problems.

Upgrade to Pro — unlock all 254 problems
Editor
SQL workspace

Run queries against the protected question data, then submit once the result shape looks right.

Sign in to run SQL

Create a free account or sign in before running queries against protected question data.