Duplicate Transactions Query

Mastercard Decision Intelligence needs to flag potentially duplicated card authorizations before they are reviewed for fraud or processing errors. Write a PostgreSQL query that compares transactions against other transactions from the same card token, merchant, currency, and amount.

Requirements

1. Treat a transaction as a duplicate candidate when the matching transaction occurs after it and no more than two minutes later.
2. Include only transactions with an approved status, and exclude the original transaction from matching with itself.
3. Use ROW_NUMBER() to rank duplicate candidates chronologically for each original transaction.
4. Return the original and duplicate transaction IDs, matching attributes, timestamps, and the candidate rank, ordered by original transaction and rank.