Duplicate Charges on the Same Day

Return the card, amount and date for charges that occur more than once with the same card and amount on the same day, together with the number of occurrences.

Table schema

Charges(id INT PRIMARY KEY, card VARCHAR(10), amount INT, charge_date DATE)

Sample data

id | card | amount | charge_date
1 | C1 | 50 | 2026-10-01
2 | C1 | 50 | 2026-10-01
3 | C1 | 20 | 2026-10-01
4 | C2 | 50 | 2026-10-01