# J.Y.S

Jump to: navigation, search

This page is to efficiently manage DBS301 Group assignments together !

## Member List

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)

## Solution

1.
YuJin

```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;
```

Saad

James

Dale

2.
YuJin

```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;
```

Saad

James

Dale

3. 2.
YuJin

Saad

James

Dale

4. 2.
YuJin

Saad

James

Dale

5. 2.
YuJin

Saad

James

Dale

6. 2.
YuJin

Saad

James

Dale