2019獨角獸企業重金招聘Python工程師標準>>> 
SELECT t.building,t.unit,t.room,t.ashcan?
,(SELECT COUNT(a.resident_id) from t_address_book a?
?where a.village_id = t.village_id AND a.building = t.building?
? and a.room = t.unit and a.house = t.room
? and a.`status` = 1
) AS regisNum
?from t_village_standard t?
where t.village_id = 317
and t.`status` = 1
