<s>[INST] Write a SQL code to find the total number of shops for each unique volume name in English.  [/INST] SELECT shop_volume_name_en, COUNT(*) AS total_shops_per_volume_name_en FROM order_transaction.transaction_detail_deprecated GROUP BY shop_volume_name_en; </s>