Changes

Jump to: navigation, search

J.Y.S

65 bytes added, 21:15, 16 October 2010
5.
<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''

Navigation menu