Count the number of shops for each unique registration channel id.

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;