vbhuk
 

3. SELECT EMPLOYEE_ID, LAST_NAME
FROM EMPLOYEES
WHERE DEPARTMENT_ID IN
(SELECT DEPARTMENT_ID
FROM EMPLOYEES
WHERE LAST_NAME LIKE '%u%')
ORDER BY DEPARTMENT_ID;

4. SELECT E.LAST_NAME, E.DEPARTMENT_ID, UPPER(E.JOB_ID) AS "JOB_ID"
FROM EMPLOYEES E, DEPARTMENTS D
WHERE D.DEPARTMENT_ID = E.DEPARTMENT_ID
AND D.LOCATION_ID = 1700
ORDER BY DEPARTMENT_ID;

5. SELECT LAST_NAME, ROUND(SALARY) AS "SALARY"
FROM EMPLOYEES
WHERE MANAGER_ID =
(SELECT EMPLOYEE_ID
FROM EMPLOYEES
WHERE LAST_NAME = "King");

6. SELECT E.DEPARTMENT_ID, E.LAST_NAME, UPPER(E.JOB_ID) AS "JOB_ID"
FROM EMPLOYEES E, DEPARTMENTS D
WHERE E.DEPARTMENT_ID = D.DEPARTMENT_ID
AND D.DEPARTMENT_NAME = "Executive";

7. SELECT EMPLOYEE_ID, LAST_NAME, ROUND(SALARY) AS "SALARY"
FROM EMPLOYEES
WHERE DEPARTMENT_ID IN
(SELECT DEPARTMENT_ID
FROM EMPLOYEES
WHERE LAST_NAME LIKE '%u%')
AND SALARY >
(SELECT AVG(SALARY)
FROM EMPLOYEES)
ORDER BY DEPARTMENT_ID;