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
[{'count(*)': 1, 'Address': 'Bridgeport'}, {'count(*)': 2, 'Address': 'Cheshire'}, {'count(*)': 3, 'Address': 'Hartford'}, {'count(*)': 4, 'Address': 'Waterbury'}]