显示那些比平均工资低的雇员信息：
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