ASSIGNMENT ON LOGICAL OPERATORS:
1. WAQTD DETAILS OF THE EMPLOYEES WORKING AS CLERK AND EARNING LESS
THAN1500.
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 INDEPT 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 WHOSE 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.
8. WAQTD DETAILS OF EMPLOYEES WORKING IN DEPT 20 OR 30.
9. WAQTD 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.
15. WAQTD 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.
18. WAQTD 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.
