Table schema:
CREATE TABLE member (address VARCHAR)

Question: Find the number of members living in each address.
SQL: SELECT COUNT(*), address FROM member GROUP BY address