Changes

J.Y.S

271 bytes added, 21:35, 19 October 2010

→‎3.

''James''

<pre>

select last_name, salary, job_id, nvl(to_char(manager_id),'No Manager') Manager#,

to_char(salary*12,'$999,999') "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 2 desc;

</pre>

1

edit