1 IRIS aun puLI C 6. Find all the employees in department 10 that have a job that same as someone in department 30.

IV. Write complete SQL statements: (30) The relational database schema of Employee Management System are defined as follows:

1 IRIS aun puLI ‘C 6. Find all the employees in department 10 that have a job that same as someone in department 30. IV. Write complete SQL statements: (30) The relational database schema of Employee Management System are defined as follows: DEPT (DEPTNO, DNAME, LOC) SALGRADE(GRADE, LOSAL, HISAL) EMP(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) Please write complete SQL statements for the following questions. 1. Find all the managers in all departments, and all the clerks in department 10. 2. Modify the salaries of all salesmen to 1.1 times of their original salaries. 3. Count the number of employees who receive a commission. 4. List all the departments that have at least two clerks. S. Find the salary grade of each employee. 6. Find all the employees in department 10 that have a job that is the same as someone in department 30.



Source link

Leave a Reply

Your email address will not be published. Required fields are marked *