Question

write and test a query to list the name and the total compensation(salary+commission) of all the instructors.Unknown commission should be treated as zero.

Answer 1

empno [Primary key], name, salary, commission, deptno

create table myemp
( 
     empno number primary key,
     name varchar2(20),
     salary number,
     commission number,
     deptno number
);

select
    name, (salary + ((salary*commission) / 100)) as "total_salary" 
from myemp;