select
client_id,
case when 
(DTAP4AGE_MONTHS_V <24 AND
MMR1AGE_MONTHS_V < 24 AND
HEPB_COMPLETE_AGE_MONTHS_V < 24 AND
HIB_COMPLETE_AGE_MONTHS_V <24 AND 
PREVNAR_COMPLETE_AGE_MONTHS_V < 24 AND
VARICELLA1AGE_MONTHS_V < 24 AND
POLIO3AGE_MONTHS_V < 24)
then 1
else 0
end as child_series_24m