Show the average salary for all departments with more than 3 people for a job.

Q. Show the average salary for all departments with more than 3 people for a job.

Answer :-

Select AVG ( Salary ) from job group by Jobtitle having count(*) > 3 ;