select dept.name, count(*) from dept, emp where dept.id=emp.dept_id group by
dept.name order by dept.name

call     count       cpu    elapsed       disk      query    current        rows
 ------- ------  -------- ---------- ---------- ---------- ----------  ----------
 
Parse         1        0 . 00         0 . 00            0            0            0             0 
Execute       1        0 . 00         0 . 00            0            0            0             0 
Fetch         3        0 . 78         0 . 81            0         1360            7            20 
 ------- ------  -------- ---------- ---------- ---------- ----------  ----------
 
total         5        0 . 78         0 . 81            0         1360            7            20 

Misses in library cache during parse:  0 
Optimizer goal: CHOOSE
Parsing user id:  18   

Rows     Row Source Operation
 -------  ---------------------------------------------------
 
      20   SORT GROUP BY 
  240000    HASH JOIN 
      21     TABLE ACCESS FULL DEPT 
  240000     TABLE ACCESS FULL EMP