Count the number of shops in each unique district (in english).

SELECT shop_district_en, COUNT(*) AS total_shops_per_district_en
FROM order_transaction.transaction_detail_deprecated
GROUP BY shop_district_en;