Changes

From CDOT Wiki
Jump to: navigation, search

J.Y.S

370 bytes added, 16:50, 20 October 2010
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>

Navigation menu