Name: Santhosh P
LOGICAL OPERATORS
ASSIGNMENT-2
1. WAQTD DETAILS OF THE EMPLOYEES WORKING AS CLERK AND EARNING
LESS THAN 1500
2. WAQTD NAME AND HIREDATE OF THE EMPLOYEES WORKING AS MANAGER
IN DEPT 30
3. WAQTD DETAILS OF THE EMP ALONG WITH ANNUAL SALARY IF THEY ARE
WORKING IN DEPT 30 AS SALESMAN AND THEIR ANNUAL SALARY HAS TO BE
GREATER THAN 14000
4. WAQTD ALL THE DETAILS OF THE EMP WORKING IN DEPT 30 OR AS ANALYST
5. WAQTD NAMES OF THE EMPMLOYEES WHOS SALARY IS LESS THAN 1100
AND THEIR DESIGNATION IS CLERK
6. WAQTD NAME AND SAL, ANNUAL SAL AND DEPTNO IF DEPTNO IS 20
EARNING MORE THAN 1100 AND ANNUAL SALARY EXCEEDS 12000
7. WAQTD EMPNO AND NAMES OF THE EMPLOYEES WORKING AS MANAGER
IN DEPT 20
[Link] DETAILS OF EMPLOYEES WORKING IN DEPT 20 OR 30.
[Link] DETAILS OF EMPLOYEES WORKING AS ANALYST IN DEPT 10.
10. WAQTD DETAILS OF EMPLOYEE WORKING AS PRESIDENT WITH SALARY OF
RUPEES 4000
11. WAQTD NAMES AND DEPTNO JOB OF EMPS WORKING AS CLERK IN DEPT
10 OR 20
12. WAQTD DETAILS OF EMPLOYEES WORKING AS CLERK OR MANAGER IN
DEPT 10.
13. WAQTD NAMES OF EMPLOYEES WORKING IN DEPT 10, 20, 30, 40.
14. WAQTD DETAILS OF EMPLOYEES WITH EMPNO 7902,7839.
[Link] DETAILS OF EMPLOYEES WORKING AS MANAGER OR SALESMAN OR
CLERK
16. WAQTD NAMES OF EMPLOYEES HIRED AFTER 81 AND BEFORE 87
17. WAQTD DETAILS OF EMPLOYEES EARNING MORE THAN 1250 BUT LESS
THAN 3000
[Link] NAMES OF EMPLOYEES HIRED AFTER 81 INTO DEPT 10 OR 30
19. WAQTD NAMES OF EMPLOYEES ALONG WITH ANNUAL SALARY FOR THE
EMPLOYEES WORKING AS MANAGER OR CLERK INTO DEPT 10 OR 30
20. WAQTD ALL THE DETAILS ALONG WITH ANNUAL SALARY IF SAL IS BETWEEN
1000 AND 4000 ANNUAL SALARY MORE THAN 15000
