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.

You can understand by seeing this video ---

 

Answer =

SELECT AVG(SALARY) FROM DEPARTMENTS GROUP BY JOB HAVING COUNT(JOB) > 3 ;