Hi All,
we have a requirement as per below,
Create table:
create table emp_test (emp_id number ,queue_name varchar2(50),qty number,price number)
/
Insert statements:
insert into emp_test values (1,'HPP',10,10)
/
insert into emp_test values (2,'Chemical',20,20)
/
insert into emp_test values (3,'Lighting',30,30)
/
insert into emp_test values (4,'SP',40,40)
/
insert into emp_test values (5,'AS',50,50)
/
commit
/
Based on above statements, we need output as below,
Emp_id | Queue_Name | Total_Cost | Final_Cost
1 | HPP | 100 | 5600
2 | Chemical | 400 | 5600
3 | Lighting | 900 | 5600
4 | SP | 1600 | 5600
5 | AS | 2500 | 5600