SELECT SUM (ProductQuant*ProductCost) 'Inventory Value', AVG (ProductCost) 'Average Product Cost', SUM (ProductQuant*ProductPrice) 'Potential Lost Revenue' FROM Product;