<s>[INST] Write a SQL code to count the number of shops for each unique registration channel ID.  [/INST] SELECT shop_register_channel_id, COUNT(*) AS total_shops_per_register_channel_id FROM order_transaction.transaction_detail_deprecated GROUP BY shop_register_channel_id; </s>