For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
select last_name, department_name, (select count(nvl(department_id, 0)) from hr.employees eee where eee.department_id=ee.department_id) as collegues from hr.employees ee join hr.departments dd on ee.department_id = dd.department_id
select last_name, department_name, (select count(nvl(department_id, 0))