write aquery to display ename,hiredate of any employee in the same dep[artment
as scott exclude scott بشرط باستخدام subquery
وجزاكم الله خيرا

الاخ الكريم
الكود بالشكل التالي

select e.ename,e.hiredate from emp e
where e.dptno in (select d.dptno from dept)
order by dptno asc