<s>[INST] Write a SQL code to find the total number of users for each unique card professional ID.  [/INST] 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; </s>