select D.NO,D.NAME,D.MEMBERCOUNT,A.AVGAGE from Dept D, (select dept_no,AVG(age) as avgage from Member group by dept_no) A WHERE d.NO=A.dept_no