Saved Bookmarks
| 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; |
|