1.

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

Answer»

SELECT AVG( sal ) FROM emp GROUP BY deptno HAVING COUNT(job)>3;



Discussion

No Comment Found

Related InterviewSolutions