SQL aassignment‐3

1.Display the average salary for each department.

2.Find the maximum and minimum salary in each job title.

3.Display the number of employees working in each department.

4.Show the total salary expense for each manager.

5.List the average commission percentage of employees grouped by job_id.

6.Display departments having more than 5 employees using HAVING.

7.Find the total number of employees hired in each year

8.Show the department name and the total salary of employees whose total salary is above 50,000.

9. Find the average salary by job_id, but display only those jobs where the average salary is above 10,000.

10. Display each manager’s ID and the count of employees reporting to them.

11.List departments where the maximum salary exceeds 12,000.

12.Display the job_id having an average salary less than 7,000.

13.Find departments having more than one distinct job_id.

14.Show job titles where the total salary paid is more than 1,00,000.

15.Display locations having more than 2 departments

16.Display the details of employees who earn more than the average salary of their department.

17.Find employees whose salary is greater than the average salary of all employees.

18.Display the department name and average salary of those departments where the average salary is greater than the company-wide average.

19.List the employees who have the highest salary in their respective departments.

20.Display the employees whose salary is less than the minimum salary of department 90.