Chapter 13 - Code Snippets
==========================

p.437, top of page:

SELECT Employees.EMPLOYEE_ID, Employees.LAST_NAME,
  Employees.JOB_ID, COUNT(Reports.EMPLOYEE_ID) AS NUM_REPORTS
FROM EMPLOYEES Employees, EMPLOYEES Reports
WHERE Employees.EMPLOYEE_ID = Reports.MANAGER_ID (+)
GROUP BY Employees.EMPLOYEE_ID, Employees.LAST_NAME,
  Employees.JOB_ID

----------------------------------------------------------------------------------