Find duplicate fraud alerts on the same card
The fraud system sometimes fires more than one alert for the same underlying event, flagging the same card twice within a short window.
An alert is a duplicate if there is an earlier alert on the same card_id within 10 minutes of it. Find every duplicate alert.
Return alert_id, card_id and alert_time, ordered by alert_id.
Schema
▸fraud_alerts
| alert_id | INT |
| card_id | TEXT |
| alert_time | TIMESTAMP |
Basic
The example input, expected output, and walkthrough for this question unlock with a Basic plan.
Basic
The reference solution and walkthrough for this question unlock with a Basic plan.
See Basic plansRM 25/mo · cancel anytime
Basic
This is a Basic question
Premium practice questions unlock with a Basic plan. The full solution, expected output, and grading are available to Basic members.
RM 25/mo · cancel anytime