Oracle Queries II

1. Count total number of employee in accounts department.
2. Display total number of employee in each department.
3. Find the difference between minimum and maximum salary of an employee.
4. Display job history of all employees including their phone number and name that are from the department administration.
5. Display name and contact number of an employee worked as Junior Admin Assistant.
6. Display position wise sum and average salary of an employee.
7. Display name of employee heading more than one department.
8. Display name, contact number of employee along with the number of department they are heading.
9. Find number of employees having salary greater than 20000.00
10. Display total salary to be paid on each position in a year,
11. Display various designation of accounts department.
12. Find total post in software design.
13. Display details of department having zero employee.
14. Display details of department having atleast 2 employees.
15. Display average salary to be given in any month.
16. Display name of department having maximum employee.
17. Display details of employee including name, address, phone  number, department name, position held, joining and ending date having minimum salary.
18. Display details of employee with designation having salary greater than average salary.
19. Display minimum, maximum, average and sum of salary of all positions.
20. Count total employee joined the organisation in the year 1981.
21. Display employee name, position, date of birth of all employee joined organisation in the month of march.
22. Display name of employee, date of birth and phone number worked as assistant administrator.
23. Display name of all engineers.
24. Display total employee worked as programmer.
25. Display details in increasing order of salary.