Difference between revisions of "J.Y.S"

From CDOT Wiki
Jump to: navigation, search
(→‎Solution: uploaded solution for quesiton 1)
(→‎Solution: uploaded solution for quesiton 2)
Line 28: Line 28:
 
[https://cs.senecac.on.ca/~nconkic/assign1.doc Assignment1]
 
[https://cs.senecac.on.ca/~nconkic/assign1.doc Assignment1]
 
==Solution==
 
==Solution==
−
1.  
+
1.
 +
<br />
 +
''YuJin''
 
<pre>
 
<pre>
 
SELECT    employee_id, RPAD(CONCAT(CONCAT(last_name, ', '),first_name), 25) "Full Name", job_id,
 
SELECT    employee_id, RPAD(CONCAT(CONCAT(last_name, ', '),first_name), 25) "Full Name", job_id,
Line 35: Line 37:
 
WHERE    TO_CHAR(hire_date, 'Mon') IN ('May', 'Nov')
 
WHERE    TO_CHAR(hire_date, 'Mon') IN ('May', 'Nov')
 
ORDER BY  hire_date DESC;
 
ORDER BY  hire_date DESC;
 +
</pre>
 +
''Saad''
 +
<pre>
 +
</pre>
 +
''James''
 +
<pre>
 +
</pre>
 +
''Dale''
 +
<pre>
 
</pre>
 
</pre>
 
2.
 
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.
 
3.
 +
2.
 +
<br />
 +
''YuJin''
 +
<pre>
 +
</pre>
 +
''Saad''
 +
<pre>
 +
</pre>
 +
''James''
 +
<pre>
 +
</pre>
 +
''Dale''
 +
<pre>
 +
</pre>
 +
 
4.
 
4.
 +
2.
 +
<br />
 +
''YuJin''
 +
<pre>
 +
</pre>
 +
''Saad''
 +
<pre>
 +
</pre>
 +
''James''
 +
<pre>
 +
</pre>
 +
''Dale''
 +
<pre>
 +
</pre>
 +
 
5.
 
5.
 +
2.
 +
<br />
 +
''YuJin''
 +
<pre>
 +
</pre>
 +
''Saad''
 +
<pre>
 +
</pre>
 +
''James''
 +
<pre>
 +
</pre>
 +
''Dale''
 +
<pre>
 +
</pre>
 +
 
6.
 
6.
 +
2.
 +
<br />
 +
''YuJin''
 +
<pre>
 +
</pre>
 +
''Saad''
 +
<pre>
 +
</pre>
 +
''James''
 +
<pre>
 +
</pre>
 +
''Dale''
 +
<pre>
 +
</pre>

Revision as of 11:55, 5 October 2010

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)

Description

Assignment1

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








					

						Retrieved from "https://wiki.cdot.senecapolytechnic.ca/w/index.php?title=J.Y.S&oldid=46911"