根据行上的先前值减少字段值

I have a table like this:

我有这样一张桌子:

Order Number  ItemCode   Quantity_Ordered   AvailableInShop
-----------------------------------------------------------
1             10         3                  3
2             10         2                  3 
Order N