<s>[INST] Write a SQL code to find the total number of shops for each unique Siam Commercial Bank (SCB) account type.  [/INST] SELECT shop_scb_account_type, COUNT(*) AS total_shops_per_scb_account_type FROM order_transaction.transaction_detail_deprecated GROUP BY shop_scb_account_type; </s>