<s>[INST] Write a SQL code to determine the total number of shops updated by each unique entity in the quality control process.  [/INST] SELECT shop_qc_updated_by, COUNT(*) AS total_shops_updated_by_entity FROM order_transaction.transaction_detail_deprecated GROUP BY shop_qc_updated_by; </s>