Example: Face Value of Inventory - Analytics Database - Teradata Vantage

You need to know the total face value for all items in your inventory.

SELECT SUM(QUANTITY * Price)
FROM Inventory;

Result:

Sum((QUANTITY * Price))
-----------------------
          38,525,151.91