1
edit
Changes
→Solution: uploaded solution for quesiton 2
[https://cs.senecac.on.ca/~nconkic/assign1.doc Assignment1]
==Solution==
1. <br />''YuJin''
<pre>
SELECT employee_id, RPAD(CONCAT(CONCAT(last_name, ', '),first_name), 25) "Full Name", job_id,
WHERE TO_CHAR(hire_date, 'Mon') IN ('May', 'Nov')
ORDER BY hire_date DESC;
</pre>
''Saad''
<pre>
</pre>
''James''
<pre>
</pre>
''Dale''
<pre>
</pre>
2.
<br />
''YuJin''
<pre>
SELECT 'Employee named ' || first_name || ' ' || last_name || ' who is '|| job_id || \
' will have a new salary of $' || salary*1.15 "Happy Employees"
FROM employees
WHERE salary BETWEEN 5000 AND 12000
AND job_id IN ('IT_PROG', 'ST_CLERK')
ORDER BY salary;
</pre>
''Saad''
<pre>
</pre>
''James''
<pre>
</pre>
''Dale''
<pre>
</pre>
3.
2.
<br />
''YuJin''
<pre>
</pre>
''Saad''
<pre>
</pre>
''James''
<pre>
</pre>
''Dale''
<pre>
</pre>
4.
2.
<br />
''YuJin''
<pre>
</pre>
''Saad''
<pre>
</pre>
''James''
<pre>
</pre>
''Dale''
<pre>
</pre>
5.
2.
<br />
''YuJin''
<pre>
</pre>
''Saad''
<pre>
</pre>
''James''
<pre>
</pre>
''Dale''
<pre>
</pre>
6.
2.
<br />
''YuJin''
<pre>
</pre>
''Saad''
<pre>
</pre>
''James''
<pre>
</pre>
''Dale''
<pre>
</pre>
