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