Find the total number of shops for each unique merchant name.

SELECT shop_merchant_name, COUNT(*) AS total_shops_per_merchant_name
FROM order_transaction.transaction_detail_deprecated
GROUP BY shop_merchant_name;