HR 11

--select emp.employee_id, last_name, salary, emp.job_id job_now, jobs.job_id job_before, rownum
SELECT last_name, salary
FROM employees emp, job_history jobs
WHERE emp.employee_id = jobs.employee_id
AND months_between(sysdate,hire_date)>120
AND UPPER(emp.job_id) NOT LIKE UPPER('%IT%')
AND UPPER(jobs.job_id) LIKE UPPER('%IT%')
AND rownum <= 3
ORDER BY salary DESC;