Changes

J.Y.S

6 bytes removed, 21:29, 16 October 2010

→‎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 e JOIN departments d

ON (e.department_id = d.department_id)

WHERE UPPER(department_name) IN ('MARKETING', 'SALES')

AND salary <

(SELECT MAX(salary)

1

edit