2. Select the lowest salary, the most recent hire date, the last name of the person who is at the top of an alphabetical list of employees, and the last name of the person who is at the bottom of an alphabetical list of employees. Select only employees who are in departments 50 or 60.

2. Write a SQL statement using employees table to display the department ID, the highest salary, and the sum of all the employees salary for every department, arranged by sum of salary from the highest to the lowest.

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

sql

database