SELECT md.MOHALA as mohala, TEMPOHKELUAR, KOD, STATUSAKTIF, count(*) as bilulama FROM mykad_data md, pengalaman pg, tahapkeluar tk where md.NAMAP = pg.NAMAP and pg.KELUARLELAKI = tk.KOD and tk.JENISKELUAR = 'L' group by pg.KELUARLELAKI order by md.MOHALA,tk.KOD