Exercise (Group By Clause)

1. Display deptno, number of employee works in each department.

2. Display job, number of employees works in each category.

3. Display job and averge salary paid for each jobs in the company.

4. Display location and sum of the salary spending for employees on that location respectively.

5. Select minimum salary, maximum salary in each department.

6. Select department number, dname, average salary for each department.

7. Select job, number of employees working in that job, maximum and minimum salary for each job.

8. Select department number, name where atleast 3 employees works.

9. Select department name, location where the average salary in each department more than 1600.

10. Select department name, job and sum of salary by each job with in the department.