SQL> select * from emp;
EMP_ID DEPT_ID EMP_NAME SALARY ------ ------ ---------- ---------- E01 D01 なまえ1 150 E02 D02 なまえ2 200 E03 D03 なまえ3 300 E04 D02 なまえ4 400 E05 D03 なまえ5 500
SQL> select 2 avg( salary ) 3 from emp ;
AVG(SALARY) ----------- 310
SQL> select 2 avg( salary ) 3 from emp 4 group by dept_id;
AVG(SALARY) ----------- 150 300 400
SQL> select 2 avg( salary ) 3 from emp 4 group by dept_id 5 having avg( salary ) > 200;
AVG(SALARY) ----------- 300 400