Determine the number of orders made using each unique card mask (last four digits of the card number).

SELECT order_card_mask, COUNT(*) AS total_orders
FROM order_transaction.transaction_detail_deprecated
GROUP BY order_card_mask;