SELECT demographic.provider_no, demographic.last_name, demographic.first_name, measurements.type, measurements.dataField, measurements.dateObserved, measurements.comments, demographic.HIN FROM measurements
JOIN demographic ON measurements.demographicNo = demographic.demographic_no
WHERE measurements.dateObserved >= DATE_SUB(CURDATE(), INTERVAL {days} DAY) AND
measurements.type = 'COUM'
ORDER by demographic.provider_no, demographic.last_name, dateEntered;