1
edit
Changes
J.Y.S
,→Solution: uploaded solution for quesiton 1
1.
<pre>
SELECT employee_id, RPAD(CONCAT(CONCAT(last_name, ', '),first_name), 25) "Full Name", job_id, TO_CHAR(TRUNC(hire_date, 'MONTH'), 'fmMonth Ddspth "in the year" YYYY') "Start Date"FROM employeesWHERE TO_CHAR(hire_date, 'Mon') IN ('May', 'Nov')ORDER BY hire_date DESC;
</pre>
2.