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
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
How many business rates are related to each cmi cross reference ? List cross reference id , master customer id and the n