J.Y.S

This page is to efficiently manage DBS301 Group assignments together !

Member List

• Email All

First Name	Last Name	wiki id	Learn e-mail	Phone
YuJin	Jeong	yujin.jeong	yjeong	647 - 832 - 6771
Saad
James
Dale

Assignment 1

Due Date

Thursday, October 21st, 4:00pm Printout submission only( SELECT Statements + ALL outputs)

Description

Assignment1

Solution

1.

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      employees
WHERE     TO_CHAR(hire_date, 'Mon') IN ('May', 'Nov')
ORDER BY  hire_date DESC;

2. 3. 4. 5. 6.