oracle笔试题

select GoodName 物品,
sum(decode(Cls,'进',Qty,0)) 进货数量,
sum(decode(Cls,'出',Qty,0)) 出货数量,
sum(decode(Cls,'进',Qty,'出',-Qty)) 当前库存
from GoodDt1
group by GoodName