显示那些比平均工资低的雇员信息：
SQL> SELECT last_name, title, salary FROM s_emp WHERE salary <
2 ( SELECT AVG(salary) FROM s_emp );
显示平均工资比“部门号是32”的平均工资大的所有部门：
SQL> SELECT dept_id, AVG(salary) FROM s_emp
2 GROUP BY dept_id HAVING AVG(salary) >
3 (SELECT AVG(salary) FROM s_emp WHERE dept_id = 32);
DEPT_ID AVG(SALARY)
------- -----------
33 1515
50 2025
找出最低平均工资的的工作：
SQL> SELECT title, AVG(salary)
2 FROM s_emp
3 GROUP BY title
4 HAVING AVG(salary) =
5 (SELECT MIN(AVG(salary))
6 FROM s_emp
7 GROUP BY title);
TITLE AVG(SALARY)
--------------------- -----------
Stock Clerk 955
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/14377/viewspace-897191/ ，如需转载，请注明出处，否则将追究法律责任。
