infant under 5 weighted last 3 months
select patient_code, first_name, last_name, dob from tracking_infant left join patient on patient.id = id_patient where timestampdiff(year,dob,now())<5 and id_patient in (select id_patient from tracking_followup where weight > 0 and timestampdiff(month, date,now())<=3 )
Comments