SELECT department_name as dname, location_name as loc, sum(employees) as number_of_employees, average(salary) as salary
FROM Emp, Dept
WHERE  Emp.deptno=Dept.deptno
GROUP BY department_name;

Hope this helps!