Practice 89 1. Find the average salary for all employees. 2. Fin d the minimum and maximum project revenue for all active projects that make money Find the number of projects that are completed. You may not use a WHERE clause. 4. Find the number of projects that have been worked on or currently are being worked 3. on by an employee. 5. Find 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 formula for the population standard deviation is as follows i--1 7. Find the number of employees who are assigned to some department. You may not 8. For each department, list the department code and the number of employees in the 9. For each department that has a project, list the department code and report the 10. Modify the query from Problem 9 to only include departments with 2 or more 11. Modify the query from Problem 10 to only count active projects. Sort the results in 12. Find the employee ID of all employees where their assigned time to work on projects 13. Calculate the salary cost for each department 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. Practice 89 1. Find the average salary for all employees. 2. Fin d the minimum and maximum project revenue for all active projects that make money Find the number of projects that are completed. You may not use a WHERE clause. 4. Find the number of projects that have been worked on or currently are being worked 3. on by an employee. 5. Find 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 formula for the population standard deviation is as follows i--1 7. Find the number of employees who are assigned to some department. You may not 8. For each department, list the department code and the number of employees in the 9. For each department that has a project, list the department code and report the 10. Modify the query from Problem 9 to only include departments with 2 or more 11. Modify the query from Problem 10 to only count active projects. Sort the results in 12. Find the employee ID of all employees where their assigned time to work on projects 13. Calculate the salary cost for each department 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