SELECT count(*) ,  address FROM member GROUP BY address
Find the number of members living in each address.
SELECT count ( * ) , address FROM member GROUP BY address
select count ( * ) , address from member group by address
Find the number of members living in each address .