1
edit
Changes
→5.
where upper(city) in ('TORONTO','OXFORD'))
and upper(job_id) not like '%PRES'
</pre>
''FINAL''
<pre>
SELECT last_name, salary, job_id
FROM employees
WHERE UPPER(job_id) 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>
