168 ) 8) Department-Wise Sum of Salaries and Max Salary

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
8) Department-Wise Sum of Salaries and Max Salary
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Question:

Write a query to find the 

Department wise - 
total sum of salaries and the maximum salary for each department.

Query:

SELECT d.departmentname,
       Sum(e.salary) AS TotalDepartmentSalary,
       Max(e.salary) AS MaximumDepartmentSalary
FROM   employees e
       JOIN departments d
         ON e.departmentid = d.departmentid
GROUP  BY d.departmentname; 

 

DepartmentName	TotalDepartmentSalary	MaximumDepartmentSalary
IT	45000	12000
HR	28000	9500

===========================