Identify the number of users for each unique crd card reference.

SELECT user_crd_card_ref, COUNT(*) AS total_users_per_crd_card_ref
FROM order_transaction.transaction_detail_deprecated
GROUP BY user_crd_card_ref;