<s>[INST] Write a SQL code to determine the number of shops associated with each unique merchant user RMID.  [/INST] SELECT shop_merchant_user_rmid, COUNT(*) AS total_shops_per_merchant_user_rmid FROM order_transaction.transaction_detail_deprecated GROUP BY shop_merchant_user_rmid; </s>