SELECT /*query3*/ dname
from new_dept
where dname in (SELECT dname
    FROM new_dept
    inner JOIN new_emp ON (
    new_emp.deptno = new_dept.deptno
    )
    where new_emp.ename is null)

select sql_id, child_number from v$sql where sql_text like '%query3%';

SELECT * FROM table(DBMS_XPLAN.DISPLAY_CURSOR('cj8pw8qmpnfab',0));