Oracle APEX. EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) DEPT (DEPTNO, DNAME, LOC) SALGRADE (GRADE, LOSAL, HISAL)
![Q: [ slide-15 .png ] Q1. Please write SQL codes to create below member database table based on…A: A relational database contains tables. Tables are also known as relations and they contain rows and…](/questions-and-answers/slide-15-.png-q1.-please-write-sql-codes-to-create-below-member-database-table-based-on-the-previous/3b4446fb-5348-4dbb-944d-a99326b9259f){kind=link}
Part 1 2 3
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)
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. Display the employee id, name, salary, commissioned salary (incremented salary +
commission) with label "Commissioned_Salary".
ii. Write a query that displays the sum of all salaries of each job.
iii. Get the average of clerks salaries.
iv. President takes maximum salary in our record. Find maximum salary of employees other
than president.
v. Show employee name, job, salary and incremented salary (25% incremented salary) of
employees.
vi. Get all Clerk or Salesman salaries that are below 3000 in descending order with respect
to sum of salaries.
vii. Show accumulated high salary and low salary from SALGRADE table.
viii. Display the highest, lowest, sum, average salary of all employees in a single query. Name
the column accordingly.
ix. Write a query to display the difference between highest and lowest salary.
x. Write a query that displays the sum of all salaries of each job.
Step by step
Solved in 3 steps
