1
edit
Changes
J.Y.S
,→5.
''YuJin''
<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>
''Saad''
<pre>
</pre>
===6.===
''YuJin''