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;