select
req_item_no ,
description ,
unit_type ,
scheduled_value ,
unit_price,
scheduled_value * unit_price ,
prev_applcations,
prev_applcations*Unit_Price,
this_period,
this_period * unit_price,
prev_applcations+this_period,
prev_applcations*Unit_Price + this_period * unit_price,
(prev_applcations*Unit_Price + this_period * unit_price)/(scheduled_value * unit_price) ,
this_period_gc
from rqdt_table where parent_key='881419Q1AZ0496CP2B1 Q '
and unit_price <>0