select distinct demo.demographic_no, dataField ,dateObserved
, demo.patient_status
from measurements, demographic demo
where type ="A1C" and dataField > {ac} and dataField < {ac1} and demo.patient_status = 'AC' and dateObserved > ((PERIOD_ADD(EXTRACT(YEAR_MONTH FROM CURDATE()),-{mon})*100)+1) and demographicNo =demo.demographic_no order by demo.last_name,demo.first_name ;
�