1
edit
Changes
J.Y.S
,→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''