You need to know the total face value for all items in your inventory.
SELECT SUM(QUANTITY * Price) FROM Inventory; Sum((QUANTITY * Price)) ----------------------- 38,525,151.91
You need to know the total face value for all items in your inventory.
SELECT SUM(QUANTITY * Price) FROM Inventory; Sum((QUANTITY * Price)) ----------------------- 38,525,151.91