Comment by madenine

SELECT TransactionID, Amount, COUNT(*) FROM Transactions GROUP BY TransactionID, Amount

I'll take 10% of savings