SQL 10.txt

SQL 10 

21.WAQTD DNAME OF THE EMPLOYEES WHOS NAME IS SMITH

SELECT DNAME
FROM DEPT
WHERE DEPTNO=(SELECT DEPTNO
FROM EMP
WHERE ENAME='SMITH');

22.WAQTD DNAME AND LOC OF THE EMPLOYEE WHOS ENAME IS KING

SELECT DNAME,LOC
FROM DEPT
WHERE DEPTNO=(SELECT DEPTNO
FROM EMP
WHERE ENAME='KING');

23.WAQTD LOC OF THE EMP WHOS EMPLOYEE NUMBER IS 7902

SELECT LOC
FROM DEPT
WHERE DEPTNO=(SELECT DEPTNO
FROM EMP
WHERE EMPNO=7902);

24.WAQTD DNAME AND LOC ALONG WITH DEPTNO OF THE EMPLOYEE WHOS NAME ENDS WITH 'R'.

SELECT DNAME,LOC,DEPTNO
FROM DEPT
WHERE DEPTNO IN (SELECT DEPTNO
FROM EMP
WHERE ENAME LIKE'%R');

25.WAQTD DNAME OF THE EMPLOYEE WHOS DESIGNATION IS PRESIDENT

SELECT DNAME
FROM DEPT
WHERE DEPTNO=(SELECT DEPTNO
FROM EMP
WHERE JOB='PRESIDENT');

26.WAQTD NAMES OF THE EMPLOYEES WORKING IN ACCOUNTING DEPARTMENT

SELECT ENAME
FROM EMP
WHERE DEPTNO = (SELECT DEPTNO
FROM DEPT
WHERE DNAME='ACCOUNTING');

27.WAQTD ENAME AND SALARIES OF THE EMPLOYEES WHO ARE WORKING IN THE LOCATION CHICAGO

SELECT ENAME,SAL
FROM EMP
WHERE DEPTNO=(SELECT DEPTNO
FROM DEPT
WHERE LOC='CHICAGO');

28.WAQTD DETAILS OF THE EMPLOYEES WORKING IN SALES

SELECT *
FROM EMP
WHERE DEPTNO=(SELECT DEPTNO
FROM DEPT
WHERE DNAME='SALES');

29.WAQTD DETAILS OF THE EMP ALONG WITH ANNUAL SALARY IF EMPLOYEES ARE WORKING IN NEW YORK

SELECT E.*,SAL*12 AS "ANNUAL SALARY"
FROM EMP E
WHERE DEPTNO=(SELECT DEPTNO
FROM DEPT
WHERE LOC='NEW YORK');

30.WAQTD NAMES OF EMPLOYEES WORKING IN OPERATIONS DEPARTMENT

SELECT ENAME
FROM EMP
WHERE DEPTNO=(SELECT DEPTNO
FROM DEPT
WHERE DNAME='OPERATIONS');