<pre>
SELECT last_name, salary, job_id,
RPAD(NVL(TO_CHAR(manager_id), 'No Manager'), 10) "Manager #", LPAD(TO_CHAR(salary*12, '$999,999'), 12) "Total Income"FROM employeesWHERE (job_id LIKE 'MK%' OR NVL(manager_id, 0) = 0IS NULL)AND salary*(1 + NVL(commission_pct,0)) + 1000 > 10000ORDER BY salary2 DESC;
</pre>
''Saad''
<pre>
</pre>
===4.===
''YuJin''
