<s>[INST] Write a SQL code to count the number of shops in each unique district (in English).  [/INST] SELECT shop_district_en, COUNT(*) AS total_shops_per_district_en FROM order_transaction.transaction_detail_deprecated GROUP BY shop_district_en; </s>