1
edit
Changes
→6.
<pre>
SELECT last_name, first_name, job_id, hire_date
FROM employeesWHERE hire_date > (SELECT MAX(hire_date) FROM employees WHERE department_id = (SELECT department_id FROM departments WHERE UPPER(department_name) = 'IT'))AND (department_id != (SELECT department_id FROM departments WHERE UPPER(department_name) = 'EXECUTIVE')OR department_id IS NULL)ORDER BY 4 DESC;
</pre>
''Saad''
