SQL – Como resolver este problema?

[Leonardo LitzParticipante]

Tente assim:

SELECT E.LAST_NAME,
D.LOCATION_ID,
D.DEPARTMENT_ID,
(SELECT COUNT(*)
FROM EMPLOYEES E2
WHERE E2.DEPARTMENT_ID = E.DEPARTMENT_ID ) QTD_FUNC
FROM EMPLOYEES E,
DEPARTMENTS D
WHERE E.DEPARTMENT_ID = D.DEPARTMENT_ID
GROUP BY E.LAST_NAME,
D.LOCATION_ID,
D.DEPARTMENT_ID


Vlw Leonardo Litz