Add minus, sum, join, column value multiplication for Oracle query result columns

Select Prod.amount,prod.plansum, (Prod.plansum-prod.amount) as borrow,d.enum_value from----result set subtraction
(Select T.quo_prod_list_price * t.quo_prod_volume as amount multiply,----column values
T.quo_prod_plan_cost * T.quo_prod_volume as Plansum, T.broad_class as Broad_class
From Cp_quotation_prod t where t.quotation_id = ' 8 ') PROD
Left Join
Cp_enum_dict D
On
Prod.broad_class = d.enum_id
Union----Connection Query rollup data row 1+ Row 2 Note that column names need to be redundant for columns that do not correspond to the column type
Select SUM (T.quo_prod_list_price * t.quo_prod_volume) as amount,
SUM (T.quo_prod_plan_cost * t.quo_prod_volume) as plansum,0 as borrow, ' 0 ' as Enum_value
From Cp_quotation_prod t where t.quotation_id = ' 8 '

Add minus, sum, join, column value multiplication for Oracle query result columns