How many residents does each property have? List property id and resident count.
SELECT T1.property_id ,  count(*) FROM properties AS T1 JOIN residents AS T2 ON T1.property_id  =  T2.property_id GROUP BY T1.property_id
SELECT T1.property_id ,  count(*) FROM properties AS T1 JOIN residents AS T2 ON T1.property_id  =  T2.property_id GROUP BY T1.property_id
[{'property_id': 107, 'count(*)': 2}, {'property_id': 108, 'count(*)': 1}, {'property_id': 120, 'count(*)': 1}, {'property_id': 373, 'count(*)': 1}, {'property_id': 445, 'count(*)': 1}, {'property_id': 605, 'count(*)': 1}, {'property_id': 629, 'count(*)': 1}, {'property_id': 669, 'count(*)': 2}, {'property_id': 748, 'count(*)': 2}, {'property_id': 879, 'count(*)': 1}, {'property_id': 954, 'count(*)': 2}]