Interview Guides
You are given transaction data from an Accenture payment reconciliation workflow. Write a SQL query to find duplicate transaction records in the transactions table, where a duplicate means multiple rows share the same account_id, merchant_name, transaction_date, and amount. Return those duplicate groups along with how many times each duplicate appears.
