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 DEPARTMENTS GROUP BY JOB HAVING COUNT (JOB) > 3;