Find the total number of users for each unique card professional id.

SELECT user_card_prof_id, COUNT(*) AS total_users_per_card_prof_id
FROM order_transaction.transaction_detail_deprecated
GROUP BY user_card_prof_id;