SELECT RPAD(CONCAT(CONCAT(first_name,' '),last_name),25) "Employee", job_id, LPAD(TRIM(TO_CHAR(salary, '$999,999')), 12, '=') "Salary", department_nameFROM employees e JOIN departmentsdUSING ON (e.department_id= d.department_id)WHERE UPPER(department_name) IN ('MARKETING', 'SALES')AND salary < (SELECT MAX(salary) FROM employees WHERE SUBSTR(job_id, 4) NOT IN ('PRES','VP','MAN','MGR')AND SUBSTR(job_id, 1, 2) IN ('MK', 'SA')ORDER BY 1;