Count the number of orders placed at each unique shop address detail.

SELECT shop_address_detail, COUNT(*) AS total_orders
FROM order_transaction.transaction_detail_deprecated
GROUP BY shop_address_detail;