ASSIGNMENT OF SQL DATE (03/11/2022)

1. WAQTD NAME OF THE EMPLOYEE ALONG WITH THEIR ANNUAL SALARY?

ANS: - select ename, sal*12 as "Annual Salary"

from emp;

2. WAQTD ENAME AND JOB FOR ALL THE EMPLOYEE WITH THEIR HALF TERM SALARY?

ANS: - select ename, sal*6 as "Half Term Salary"

from emp;

3. WAQTD ALL THE DETAILS OF THE EMPLOYEES ALONG WITH AN ANNUAL BONUS OF 2000?

ANS: - select emp.*,sal*12+2000 as Bonus

from emp;

4. WAQTD NAME SALARY AND SALARY WITH A HIKE OF 10%?

ANS: - select ename, sal, sal*0.1+sal as "Salary With 10% Hike"

from emp;

5. WAQTD NAME AND SALARY WITH DEDUCTION OF 25%.

ANS: - select ename, sal-(sal*0.25) as "Deduction of 25 %"

from emp;

6. WAQTD NAME AND SALARY WITH MONTHLY HIKE OF 50?

ANS: - select ename, sal+50 as "Monthly Hike of 50 Rs"

from emp;

7. WAQTD NAME AND SALARY WITH DEDUCTION OF 10%?

ANS: - select ename, sal-(sal*.10) as "Deduction of 10 %"

from emp;

8. WAQTD TOTAL SALARY GIVEN TO EACH EMPLOYEE (SAL+COMM)?

ANS: - select emp.*, sal+comm as "Salary with Commission"

from emp;

9. WAQTD DETAILS OF ALL THE EMPLOYEES ALONG WITH ANNUAL SALARY?

ANS: - select emp.*, sal*12 as "Annual Salary"

from emp;

10. WAQTD NAME AND DESIGNATION ALONG WITH 100 PENALTY IN SALARY?

ANS: - select ename, job, sal-100 as "Salary With 100 Rs Penalty"

from emp;
DATE (04/11/2022)

11. WAQTD THE ANNUAL SALARY OF THE EMPLOYEE WHOS NAME IS SMITH?

ANS: - select ename, sal*12 as "Annual Salary"

from emp

where ename='SMITH';

12. WAQTD NAME OF THE EMPLOYEES WORKING AS CLERK?

ANS: - select ename from emp

where job='CLERK';

13. WAQTD SALARY OF THE EMPLOYEES WHO ARE WORKING AS SALESMAN?

ANS: - select sal

from emp

where job='SALESMAN';

14. WAQTD DETAILS OF THE EMP WHO EARNS MORE THAN 2000?

ANS: - select * from emp

where sal>2000;

15. WAQTD DETAILS OF THE EMP WHOS NAME IS JONES?

ANS: - select * from emp

where ename='JONES';

16. WAQTD DETAILS OF THE EMP WHO WAS HIRED AFTER 01-JAN-81?

ANS: - select * from emp

where hiredate>'01/JAN/1981';

17. WAQTD NAME AND SAL ALONG WITH HIS ANNUAL SALARY IF THE ANNUAL SALARY IS MORE
THAN 12000?

ANS: - select ename, sal*12 as "Annual Salary"

from emp

where sal*12>12000;

18. WAQTD EMPNO OF THE EMPLOYEES WHO ARE WORKING IN DEPT 30?

ANS: - select empno from emp

where DEPTNO=30;

19. WAQTD ENAME AND HIREDATE IF THEY ARE HIRED BEFORE 1981?

ANS: - select ename, hiredate from emp

20. WAQTD DETAILS OF THE EMPLOYEES WORKING AS MANAGER?

ANS: - select * from emp

where job='MANAGER';

21. WAQTD NAME AND SALARY GIVEN TO AN EMPLOYEE IF EMPLOYEE EARNS A COMMISSION
OF RUPEES 1400?

ANS: - SELECT ENAME, SAL FROM EMP

WHERE COMM='1400';

22. WAQTD DETAILS OF EMPLOYEES HAVING COMMISSION MORE THAN SALARY?

ANS: - SELECT * FROM EMP

WHERE COMM>SAL;

23. WAQTD EMPNO OF EMPLOYEES HIRED BEFORE THE YEAR 87?

ANS: - SELECT EMPNO FROM EMP

WHERE HIREDATE<'01/JAN/1987';

24. WAQTD DETAILS OF EMPLOYEES WORKING AS AN ANALYST?

ANS: - SELECT * FROM EMP

WHERE JOB='ANALYST';

25. WAQTD DETAILS OF EMPS EARNING MORE THAN 2000 RUPEES PER MONTH?

ANS: - SELECT * FROM EMP

WHERE SAL>2000;

DATE (07/11/2022)

26. WAQTD DETAILS OF THE EMPLOYEES WORKING AS CLERK AND EARNING LESS THAN 1500?

ANS: - SELECT * FROM EMP

WHERE JOB='CLERK' AND SAL<1500;

27. WAQTD NAME AND HIREDATE OF THE EMPLOYEES WORKING AS MANAGER IN DEPT 30?

ANS: - SELECT ENAME, HIREDATE FROM EMP

WHERE JOB='MANAGER' AND DEPTNO=30;

28. 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?

ANS: - SELECT EMP.*, SAL*12 AS "ANNUAL SALARY" FROM EMP

WHERE DEPTNO=30 AND JOB='SALESMAN' AND SAL*12>14000;

ANS: - SELECT * FROM EMP

WHERE DEPTNO=30 OR JOB='ANALYST';

30. WAQTD NAMES OF THE EMPMLOYEES WHOS SALARY IS LESS THAN 1100 AND THEIR
DESIGNATION IS CLERK?

ANS: - SELECT ENAME FROM EMP

WHERE SAL<1100 AND JOB='CLERK';

31. WAQTD NAME AND SAL , ANNUAL SAL AND DEPTNO IF DEPTNO IS 20 EARNING MORE THAN
1100 AND ANNUAL SALARY EXCEEDS 12000?

ANS: - SELECT ENAME, SAL, DEPTNO, SAL*12 "ANNUAL SALARY" FROM EMP

WHERE DEPTNO=20 AND SAL>1100 AND SAL*12>12000;

32. WAQTD EMPNO AND NAMES OF THE EMPLOYEES WORKING AS MANAGER IN DEPT?

ANS: - SELECT EMPNO, ENAME FROM EMP

WHERE JOB='MANAGER' AND DEPTNO=20;

33. WAQTD DETAILS OF EMPLOYEES WORKING IN DEPT 20 OR 30 ?

ANS: - SELECT * FROM EMP

WHERE DEPTNO=20 OR DEPTNO=30;

34. WAQTD DETAILS OF EMPLOYEES WORKING AS ANALYST IN DEPT 10?

ANS: - SELECT * FROM EMP

WHERE JOB='ANALYST' AND DEPTNO=10;

35. WAQTD DETAILS OF EMPLOYEE WORKING AS PRESIDENT WITH SALARY OF RUPEES 4000?

ANS: - SELECT * FROM EMP

WHERE JOB='PRESIDENT' AND SAL=4000;

36. WAQTD NAMES AND DEPTNO , JOB OF EMPS WORKING AS CLERK IN DEPT 10 OR 20?

ANS: - SELECT ENAME, DEPTNO FROM EMP

WHERE JOB='CLERK' AND (DEPTNO=10 OR DEPTNO=20);

37. WAQTD DETAILS OF EMPLOYEES WORKING AS CLERK OR MANAGER IN DEPT 10?

ANS: - SELECT * FROM EMP

WHERE (JOB='CLERK' OR JOB='MANAGER') AND DEPTNO=10;

38. WAQTD NAMES OF EMPLOYEES WORKING IN DEPT 10 , 20 , 30 , 40?

ANS: - SELECT ENAME FROM EMP

WHERE DEPTNO=10 OR DEPTNO=20 OR DEPTNO=30 OR DEPTNO=40;

ANS: - SELECT * FROM EMP

WHERE EMPNO=7902 OR EMPNO=7839;

40. WAQTD DETAILS OF EMPLOYEES WORKING AS MANAGER OR SALESMAN OR CLERK?

ANS: - SELECT * FROM EMP

WHERE JOB='MANAGER' OR JOB='CLERK' OR JOB='SALESMAN';

41. WAQTD NAMES OF EMPLOYEES HIRED AFTER 81 AND BEFORE 87?

ANS: - SELECT ENAME FROM EMP

WHERE HIREDATE>'31/DEC/1981' AND HIREDATE<'01/JAN/1987';

42. WAQTD DETAILS OF EMPLOYEES EARNING MORE THAN 1250 BUT LESS THAN 3000?

ANS: - SELECT * FROM EMP

WHERE SAL>1250 AND SAL<3000;

43. WAQTD NAMES OF EMPLOYEES HIRED AFTER 81 INTO DEPT 10 OR 30?

ANS: - SELECT ENAME FROM EMP

WHERE HIREDATE>'31/DEC/1981' AND (DEPTNO=10 OR DEPTNO=30);

44. WAQTD NAMES OF EMPLOYEES ALONG WITH ANNUAL SALARY FOR THE EMPLOYEES
WORKING AS MANAGER OR CLERK INTO DEPT 10 OR 30?

ANS: - SELECT ENAME, SAL*12 "ANNUAL SALARY" FROM EMP

WHERE JOB='MANAGER' OR JOB='CLERK' OR DEPTNO=10 OR DEPTNO=30;

45. WAQTD ALL THE DETAILS ALONG WITH ANNUAL SALARY IF SAL IS BETWEEN 1000 AND 4000
ANNUAL SALARY MORE THAN 15000.

ANS: - SELECT EMP.*, SAL*12 "ANNUAL SALARY" FROM EMP

WHERE SAL>1000 AND SAL<4000 AND SAL*12>15000;