<s>[INST] Write a SQL code to count the number of shops in each unique subdistrict based on their addresses.  [/INST] SELECT shop_address_subdistrict, COUNT(*) AS total_shops_per_subdistrict FROM order_transaction.transaction_detail_deprecated GROUP BY shop_address_subdistrict; </s>