CREATE TABLE member (address VARCHAR2)

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"