Changes

J.Y.S

329 bytes added, 21:07, 19 October 2010

→‎3.

</pre>

''Saad- THIS ANSWER IS DIFFERENT FROM ^''

<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 (manager_id IS NULL

OR job_id LIKE 'MK%')

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

ORDER BY salary DESC

/

</pre>

''James''

1

edit