. rind the last name of the employee whose last name is last in dictionary order 6. Compute the employee salary standard deviation. As a reminder the tormula for the population standard deviation is as follows 7. Find the number of employecs who are assigned to some department. You may no: 8. For each department, list the department code and the number of emplcyees in the 9 tur each department that has a project, list the department code and report the 10, Mocify thie query from Problem 9 to only include departments with 2 or more 1L. Modify the query from Problem 10 to only count active projecis. Sort the resul's in 12, Find the emplovee l) of all employees where their assigned tline to work on projerts 13. Calculate the salary cost for each deparunent with employees that don't have a last use a WHERE clause. department. average revenue and count of all of its projects. projects descending order by count. is 100% or more. name ending in-re, after giving everyone a 10% raise