select gg.GroupName, count(*) howmany from users uu
join Memberships mm on uu.UID = mm.uid
join Groups gg on mm.GID = gg.GID
group by gg.GroupName