Top Transaction per Card by Amount

A product manager wants to identify the single largest transaction made on each card, along with key card and merchant details, to analyze customer purchasing behavior. For every card that has recorded at least one transaction, provide the card’s identifier, last four digits, network, the transaction ID of its highest-value transaction, the transaction amount, timestamp, the merchant’s name, and the merchant’s category. If a card has multiple transactions for the same highest amount, include the one that occurred earliest.