select e_id,e_name,avg(salary),max(salary),min(salary)from dep,emp where dep.d_id=emp.d_id group by e_id,e_name;