EMP: NUMBER (4) EMPNO VARCHAR2 (10) ΕΝΑΜΕ VARCHAR2 (9) JOB NUMBER (4) MGR HIREDATE DATE NUMBER (7, 2) SAL NUMBER (7, 2) СOMM NUMBER (2) DE PTNΟ DEPT: NUMBER (2) DE PTNΟ VARCHAR2 (14) DNAME VARCHAR2...


- Find the total amount of money needed in order to give 5% salary increase to all mangers and 4% increase to everybody else.


- Find each employee who is making more than the average of his or her job line


EMP:<br>NUMBER (4)<br>EMPNO<br>VARCHAR2 (10)<br>ΕΝΑΜΕ<br>VARCHAR2 (9)<br>JOB<br>NUMBER (4)<br>MGR<br>HIREDATE<br>DATE<br>NUMBER (7, 2)<br>SAL<br>NUMBER (7, 2)<br>СOMM<br>NUMBER (2)<br>DE PTNΟ<br>DEPT:<br>NUMBER (2)<br>DE PTNΟ<br>VARCHAR2 (14)<br>DNAME<br>VARCHAR2 (13)<br>LOC<br>

Extracted text: EMP: NUMBER (4) EMPNO VARCHAR2 (10) ΕΝΑΜΕ VARCHAR2 (9) JOB NUMBER (4) MGR HIREDATE DATE NUMBER (7, 2) SAL NUMBER (7, 2) СOMM NUMBER (2) DE PTNΟ DEPT: NUMBER (2) DE PTNΟ VARCHAR2 (14) DNAME VARCHAR2 (13) LOC

Jun 04, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?