How many business rates are related to each cmi cross reference? List cross reference id, master customer id and the n
SELECT T2.cmi_cross_ref_id ,  T2.master_customer_id ,  count(*) FROM Business_Rates AS T1 JOIN CMI_Cross_References AS T2 ON T1.cmi_cross_ref_id  =  T2.cmi_cross_ref_id GROUP BY T2.cmi_cross_ref_id
SELECT T2.cmi_cross_ref_id ,  T2.master_customer_id ,  count(*) FROM Business_Rates AS T1 JOIN CMI_Cross_References AS T2 ON T1.cmi_cross_ref_id  =  T2.cmi_cross_ref_id GROUP BY T2.cmi_cross_ref_id
[{'cmi_cross_ref_id': 49, 'master_customer_id': 1, 'count(*)': 1}, {'cmi_cross_ref_id': 95, 'master_customer_id': 2, 'count(*)': 1}, {'cmi_cross_ref_id': 99, 'master_customer_id': 9, 'count(*)': 1}]