select `address_id`,avg(age),(select `street` from `address` where `person`.`address_id` = `address`.`id` ) `address` from `person` group by `address_id` []