Changes

Jump to: navigation, search

J.Y.S

349 bytes added, 13:22, 5 October 2010
4.: uploaded solution for 4
''YuJin''
<pre>
SELECT RPAD(CONCAT(CONCAT(first_name,' '),last_name),25) "Employee",
job_id, LPAD(TRIM(TO_CHAR(salary, '$999,999')), 12, '=') "Salary", department_name
FROM employees JOIN departments
USING (department_id)
WHERE SUBSTR(job_id, 4) NOT IN ('PRES','VP','MAN','MGR')
AND SUBSTR(job_id, 1, 2) IN ('MK', 'SA')
ORDER BY 1;
</pre>
''Saad''

Navigation menu