<s>[INST] Write a SQL code to count the number of orders placed at each unique shop address detail.  [/INST] SELECT shop_address_detail, COUNT(*) AS total_orders FROM order_transaction.transaction_detail_deprecated GROUP BY shop_address_detail; </s>