--- group by

A `group by' clause lets you specifically divide selected records into
   groups.

It is always used in conjunction with a `having' clause.


EXAMPLE:

	  sql> select dept_no, avg(salary)
	  sql> from emp
	  sql> group by dept_no
          sql> having avg(salary) > 2000/
