1.
WAQTD THE NAME AND SALARY OF ALL THE EMPLOYEES WHO ARE WORKING IN DEPTNO 10 WITH
SALARY MORETHAN 2000
SELECT ENAME, SAL, DEPTNO
FROM EMP
WHERE DEPTNO = 10 AND SAL > 2000;
2.WAQTD NAME AND HIREDATE OF THE EMPLOYEES WORKING AS MANAGER IN DEPT 30
SELECT ENAME, DEPTNO, HIREDATE, JOB
FROM EMP
WHERE JOB='MANAGER' AND DEPTNO=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
SELECT EMP.*, SAL*12 AS ANUALSAL
FROM EMP
WHERE DEPTNO = 30 AND JOB = 'SALESMAN' AND SAL*12 > 14000;
4.WAQTD ALL THE DETAILS OF THE EMP WORKING IN DEPT 30 OR AS ANALYST.
SELECT *
FROM EMP
WHERE DEPTNO = 30 OR JOB = 'ANALYST';
5.WAQTD NAMES OF THE EMPMLOYEES WHOS SALARY IS LESS THAN 1100 AND THEIR DESIGNATION
IS CLERK
SELECT ENAME, JOB
FROM EMP
WHERE SAL <1100 AND JOB = '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
