<pre>
SELECT last_name, salary, job_id
FROM employeesWHERE UPPER(job_id) NOt NOT LIKE '%PRES'AND salary > (SELECT MAX(salary) FROM employees JOIN departments USING (department_id) JOIN locations USING (location_id) WHERE UPPER(city) IN ('TORONTO','OXFORD'));
</pre>
''Saad''