SELECT *
FROM
(
SELECT dxresearch_code, count(d.demographic_no) as 'Number'
FROM dxresearch dx, demographic d
WHERE dx.status='A'
AND d.patient_status = 'AC'
AND dxresearch_code not in ('V68','V688','V6889')
AND d.provider_no ='{provider_no}'
AND dx.demographic_no = d.demographic_no
GROUP BY dxresearch_code WITH ROLLUP
) a
WHERE Number > 0
ORDER BY dxresearch_code
;
select provider_no,concat(last_name,',',first_name,'(',provider_no,')')
from provider
where status='1'
and provider_type='doctor'
and ohip_no>1
order by provider_no;