SELECT *, COUNT(A.PERSONID) AS COUNT
FROM MAATTEND AS A
JOIN MAGROUPS AS G ON (G.ACTID=A.ACTID)
JOIN MAPEOPLE AS P ON (P.MEMBERID=A.PERSONID)
JOIN MAHOUSE AS H ON (P.FAMILYID=H.FAMILYID)
WHERE (A.VISITOR=TRUE) AND (A.ACTID=101) AND
      (A.MEETDATE >= '2003-11-01') AND (A.MEETDATE <= '2003-11-30')
GROUP BY A.PERSONID
ORDER BY P.FULLNAME