Create a query that lists the department number, employee number, and salaries of all employees in department D11. UNION the same information , but this time sum up all the salaries to create a one...

Create a query that lists the department number, employee number, and salaries of all employees in department D11.

 UNION the same information , but this time sum up all the salaries to create a one line summary entry for the D11 department (hint sum the salary). Sort the list by Salary.