, sum(sub.amount) as amount
, sum(greatest(least(sub.quantity, qoh.quantity - quantity_before), 0))
, sum(sub.amount*greatest(least(sub.quantity, qoh.quantity - quantity_before), 0)/sub.quantity)
, sum(sub.amount) as amount
, sum(greatest(least(sub.quantity, qoh.quantity - quantity_before), 0))
, sum(sub.amount*greatest(least(sub.quantity, qoh.quantity - quantity_before), 0)/sub.quantity)