SELECT MRP, SUM(IF(IFNULL(Number_A1Cs_in_Last_12_Months,0) >= 2, 1, 0)) AS Two_or_More_A1Cs, COUNT(*) AS Number_of_Patients_40_or_Older_w_DM, CONCAT( ROUND( (SUM(IF(IFNULL(Number_A1Cs_in_Last_12_Months,0) >= 2, 1, 0)) / COUNT(*)) *100, 2),'%') AS Percent FROM (SELECT demographic.demographic_no AS Demo, MRP FROM demographic, (SELECT provider_no, last_name AS MRP FROM provider WHERE specialty LIKE '%MRP%' ) AS MRP WHERE patient_status IN ('AC','GROUP HOME') AND demographic.provider_no = MRP.provider_no AND YEAR(CURDATE())-demographic.year_of_birth-(DATE_FORMAT(CURDATE(),'00-%m-%d')= 40 ) AS Patients, (SELECT DISTINCT demographic_no FROM dxresearch, icd9 WHERE dxresearch.dxresearch_code = icd9.icd9 AND coding_system = 'icd9' AND description LIKE '%diabete%' AND description NOT LIKE '%fam%' AND description NOT LIKE '%pre%' AND description NOT LIKE '%insi%' AND status = 'A' UNION DISTINCT SELECT DISTINCT dxresearch.demographic_no FROM dxresearch, encodeFm WHERE dxresearch.dxresearch_code = encodeFm.EncodeFm AND coding_system = 'encodeFm' AND (description LIKE '%diabete%' OR description LIKE '%dm type%') AND description NOT LIKE '%fam%' AND description NOT LIKE '%pre%' AND description NOT LIKE '%insi%' AND dxresearch.status = 'A' ) AS Diabetes_Dx LEFT JOIN (SELECT demographicNo AS demographic_no, COUNT(DISTINCT DATE(dateObserved)) AS Number_A1Cs_in_Last_12_Months FROM measurements WHERE type = 'A1C' AND dataField <> '' AND dateObserved BETWEEN ADDDATE(CURDATE(), INTERVAL -12 MONTH) AND CURDATE() GROUP BY demographicNo ) AS Agg_measurements ON Diabetes_Dx.demographic_no = Agg_measurements.demographic_no WHERE Diabetes_Dx.demographic_no = Patients.Demo GROUP BY MRP WITH ROLLUP ;