Determine the total number of shops updated by each unique entity in the quality control process.

SELECT shop_qc_updated_by, COUNT(*) AS total_shops_updated_by_entity
FROM order_transaction.transaction_detail_deprecated
GROUP BY shop_qc_updated_by;