Changes

J.Y.S

372 bytes added, 16:38, 20 October 2010

→‎3.

and salary * (1 + nvl(commission_pct, 0)) + 1000 > 10000

order by 2 desc;

</pre>

''FINAL''

<pre>

SELECT last_name, salary, job_id,

SUBSTR(NVL(TO_CHAR(manager_id), 'No Manager'), 1, 10) "Manager #",

LPAD(TO_CHAR(salary * 12, '$999,999'), 12) "Total Income"

FROM employees

WHERE (UPPER(job_id) LIKE 'MK%' OR manager_id IS NULL)

AND salary * (1 + NVL(commission_pct, 0)) + 1000 > 10000

ORDER BY salary DESC;

</pre>

1

edit