SELECT DISTINCT CONCAT( "/", demo.demographic_no, "/" ) AS "Demo" , CONCAT(demo.last_name, ', ', demo.first_name) as Patient, drugs.bn as Statin, (select concat(pr.first_name, ' ', pr.last_name) from provider pr where pr.provider_no = demo.provider_no) as Provider FROM demographic demo, drugs WHERE (drugs.atc LIKE 'C10AA%' OR drugs.atc LIKE 'C10BA%' OR drugs.atc LIKE 'C10BX%') AND demo.patient_status = 'AC' AND demo.provider_no in ({provider}) AND demo.demographic_no=drugs.demographic_no group by last_name, first_name with rollup ; select provider_no, CONCAT(last_name) from provider WHERE status='1' AND provider_type='doctor' AND ohip_no>1 ORDER BY last_name;