1
edit
Changes
→3.
</pre>
''Saad - THIS ANSWER RESULT IS DIFFERENT FROM ^''
<pre>
SELECT last_name, salary, job_id, NVL(TO_CHAR(manager_id),'No Manager') Manager#,
WHERE (manager_id IS NULL
OR job_id LIKE 'MK%')
AND (salary+1000 * (NVL(commission_pct,0) + 100)+ 1000 ) > 10000
ORDER BY salary DESC
/
</pre>
''James''
