SQL & PL/SQL

Hi ,

Please help in how to do this . I want to extract  hierarchical information along with  count of sub nodes for each node .

For Example    1   has 11 sub nodes under it

                       2  has 4

                       3  has 0

                       4 has 2

                        9 has 3

taking the example of employees table i execute this query

select employee_id,

      manager_id

        ,level

       ,LPAD(' ', LEVEL*3) || LAST_NAME AS LAST_NAME,

       sys_connect_by_path (last_name , '/') sys_path_connection

       from employees

       start with manager_id is null

       CONNECT BY PRIOR employee_id = manager_id

       and last_name not in ( 'Kochhar' ,'Raphaely' ,'Weiss','Fripp' , 'Kaufling' , 'Vollman' , 'Mourgos' , 'Russell' , 'Partners'

                              ,'Errazuriz' , 'Cambrault'  ,'Hartstein' );

In this query , how i can get count of all subnodes under a node like under King , it should give me 13, under De Hann it should give me 5