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