Find the total number of shops assigned to each unique quality control (qc) assignee.

SELECT shop_qc_assignee_id, COUNT(*) AS total_shops_per_qc_assignee
FROM order_transaction.transaction_detail_deprecated
GROUP BY shop_qc_assignee_id;