oracle assgn 5

1. Display the highest, lowest, sum, and average salary of all employees. Label the columns Maximum, Minimum, Sum, and Average, respectively. Place your SQL statement in a text file named lab5_1.sql.
2. Display highest, lowest, average salary of the employees whose job ID contains keyword R&D.

3. Count the total number of employees whose department_id =50

4. Display the number of department values in the EMPLOYEES table.

5. Display the number of distinct department values in the EMPLOYEES table.

6. Display the average salaries for each department

7. Display the total salary of the employees for each job on each department.

8. Display the average salary above 8000 of the employees for each department.

9. Display the maximum salary above 8000 for each department.

10. Display the job ID and total monthly salary for each job with a total payroll exceeding $13,000. sort the list by the total monthly salary.

11. Display the maximum average salary for each department.

12. Write a query to display the number of people with the same job.

13 Determine the number of managers without listing them. Label the column Number of Managers. Hint: Use the MANAGER_ID column to determine the number of managers.

14. Write a query that displays the difference between the highest and lowest salaries. Label the column DIFFERENCE.

15. Display the manager number and the salary of the lowest paid employee for that manager. Exclude anyone whose manager is not known. Exclude any groups where the minimum salary is $6,000 or less. Sort the output in descending order of salary.