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;