how many residents does each property have?list 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
find the property type code and address for the property id 24
select property_type_code, property_address from properties where property_id = 24
find the date moved in for the resident id 6
select date_moved_in from residents where resident_id = 6