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
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
How many residents does each property have ? List property id and resident count .