Write a SQL query to get the only Super Child records from the Table, Sql Server

Language: Layout:

create table JobCollection (
        JCId int
      , JCName varchar(50)
      , JCParentId  int
      , JCParentName varchar(50)
    );
    
    insert into JobCollection values 
     ( 1, 'A'  , null, null)
    ,( 2, 'B'  , null, null)
    ,( 3, 'A1' , 1, null)
    ,( 4, 'A2' , 1, null)
    ,( 5, 'A3' , 1, null)
    ,( 6, 'B1' , 2, null)
    ,( 7, 'B2' , 2, null)
    ,( 8, 'A11', 3, null)
    ,( 9, 'A12', 3, null)
    ,(10, 'A21', 4, null)
    ,(11, 'A31', 5, null)
    ,(12, 'A32', 5, null)
    ,(13, 'B11', 6, null)
    ,(14, 'B12', 6, null)
    ,(15, 'B21', 7, null)
    ,(16, 'B22', 7, null);

declare @ParentId int;
    set @ParentId = 1;

with cte as (
      select  JCId, JCName, JCParentId, JCParentName
        from  JobCollection
        where JCId = @ParentId
      union all
      select c.JCId, c.JCName, c.JCParentId, JCParentName = p.JCName
        from JobCollection c
          inner join cte p on p.JCId = c.JCParentId 
    )
    select JCId, JCName, JCParentId, JCParentName
    from cte as o
    where not exists (
      select 1 
        from cte as i
        where o.JCid = i.JCParentId
      )

View schema
Execution time: 0,03 sec, rows selected: 6, rows affected: 16, absolute service time: 0,19 sec