SCHEMA:
CREATE TABLE member (address VARCHAR)
USER:
Find the number of members living in each address.

QUERY:
SELECT COUNT(*), address FROM member GROUP BY address