How to query the average salary for all the departments employing more than 3 people?

abhinav.abinav

 Profile Answers by abhinav.abinav Questions by abhinav.abinav

• Jan 13th, 2010

Select deptno,avg(sal),count(*) from emp group by deptno having count(*)>3;

Answer Question  Select Best Answer

Write a query to display the average, monthly salary bill for each job type within a department.

abhinav.abinav

 Profile Answers by abhinav.abinav Questions by abhinav.abinav

• Jan 13th, 2010

Select job,deptno,avg(sal) from emp group by job,deptno;

Answer Question  Select Best Answer