select pid, title from lists where diagnosis="ICD10:E11.9";
// List of patients with diabetes diagnosis 568 patients
select patient_data.ss as seqn, patient_data.fname, patient_data.lname ,
convert(procedure_result.result,decimal(10,2)) as a1c
FROM procedure_result,procedure_report,procedure_order,patient_data
WHERE procedure_result.procedure_report_id=procedure_report.procedure_report_id
AND procedure_report.procedure_order_id=procedure_order.procedure_order_id
AND patient_data.pid = procedure_order.patient_id
AND procedure_result.result_code="4548-4"
AND convert(procedure_result.result,decimal(10,2)) > 9
AND (patient_data.pid in (select pid from lists where diagnosis="ICD10:E11.9") );
// Of these patients who’s a1c levels were 9.0 or higher (85 patients)
select patient_data.ss as seqn, patient_data.fname, patient_data.lname
,convert(procedure_result.result,decimal(10,2)) as a1c
FROM procedure_result,procedure_report,procedure_order,patient_data
WHERE procedure_result.procedure_report_id=procedure_report.procedure_report_id
AND procedure_report.procedure_order_id=procedure_order.procedure_order_id
AND patient_data.pid = procedure_order.patient_id
AND procedure_result.result_code="4548-4"
AND convert(procedure_result.result,decimal(10,2)) > 9
AND (patient_data.pid NOT IN (select pid from lists where diagnosis="ICD10:E11.9") )
// Then who didn’t have a diagnosis of diabetes listed, but does have a1c > 9 // 55 patients