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