select v.GP_CODE, v.NAME, ca.ATTENDANCESTATUS, ch.person_id  from village v , classattending ca, school s, class c, person p,child ch  where v.id = s.village_id and c.ID = ca.CLASS_ID and ca.ATTENDANCESTATUS='SG' and p.BIRTHDATE between DATE '1976-06-21' and DATE '1984-06-21';