SELECT d.dept_name AS dname, d.loc_name AS loc, COUNT(*) AS [Number of employees], CAST(AVG(salary) AS numeric(10, 2)) AS [Salary]

FROM dbo.EMP e

INNER JOIN dbo.DEPT d ON d.deptno = e.deptno

GROUP BY d.dept_name, d.loc_name