SQL Server, Primavera P6 Professional

select * -- projects
from PROJWBS p left join task t on p.proj_id = t.proj_id and p.wbs_id = t.wbs_id
where p.parent_wbs_id not in (select wbs_id from PROJWBS where proj_id = p.proj_id)
order by task_code;