1
edit
Changes
→Solution: uploaded solution for quesiton 3
[https://cs.senecac.on.ca/~nconkic/assign1.doc Assignment1]
==Solution==
===1.<br />===
''YuJin''
<pre>
<pre>
</pre>
===2.<br />===
''YuJin''
<pre>
<pre>
</pre>
===3.2.<br />===
''YuJin''
<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 (job_id LIKE 'MK%' OR NVL(manager_id, 0) = 0)
AND salary*(1 + NVL(commission_pct,0)) + 1000 > 10000
ORDER BY salary;
</pre>
''Saad''
</pre>
===4.2.<br />===
''YuJin''
<pre>
</pre>
===5.2.<br />===
''YuJin''
<pre>
</pre>
===6.2.<br />===
''YuJin''
<pre>
