Following script is given to you at Google Classroom. Run script to generate tables in Oracle APEX. EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) DEPT (DEPTNO, DNAME, LOC) SALGRADE (GRADE, LOSAL, HISAL) INSTRUCTOR: HAROON SHAHZAD 2 After setting up all relations, you need to apply following queries to get data from given relations: (Write queries and also paste screenshots in answer file) i. Give data of all employees whose salary is greater than 5000. ii. Give only those departments name whose deptno is 30 and Location is New York. iii. Display the employee name, job id and start date of employees hired between February 20, 1998 and May, 1, 1998. Order the query in ascending order by hire date. iv. Display the data of all employees who do not have managers. (means whose managers are null) v. Display the names of all employees where the third letter of the name is ‘a’. vi. Write a query to display all employee records who have been hired in month February. vii. Give all employees records who have salary in between 1000 and 2000 (both included) viii. Get all employee names whose name second letter is ‘A’. ix. Retrieve all employees records who doesn’t take commission. x. Get all employees records who work as ‘CLERK’.

Following script is given to you at Google Classroom. Run script to generate tables in
Oracle APEX.

EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)
DEPT (DEPTNO, DNAME, LOC)
SALGRADE (GRADE, LOSAL, HISAL)

INSTRUCTOR: HAROON SHAHZAD 2
After setting up all relations, you need to apply following queries to get data from given
relations: (Write queries and also paste screenshots in answer file)

i. Give data of all employees whose salary is greater than 5000.
ii. Give only those departments name whose deptno is 30 and Location is New York.
iii. Display the employee name, job id and start date of employees hired between February
20, 1998 and May, 1, 1998. Order the query in ascending order by hire date.
iv. Display the data of all employees who do not have managers. (means whose managers
are null)
v. Display the names of all employees where the third letter of the name is ‘a’.
vi. Write a query to display all employee records who have been hired in month February.
vii. Give all employees records who have salary in between 1000 and 2000 (both included)
viii. Get all employee names whose name second letter is ‘A’.
ix. Retrieve all employees records who doesn’t take commission.
x. Get all employees records who work as ‘CLERK’.