select `address_id`,avg(age) `avgage`,(select `street` from `address` where `person`.`address_id` = `address`.`id` ) `address` from `person` group by `address_id` having `avgage` > 10 [:a]