Tilted Forum Project Discussion Community - View Single Post

aa1037 · 04-19-2006, 09:23 PM

I GOT IT! The following code yielded the proper results:

Code:

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

04-19-2006, 09:23 PM	#2 (permalink)
aa1037 Insane Location: New York	I GOT IT! The following code yielded the proper results: Code: SELECT SUM (ProductQuantProductCost) 'Inventory Value', AVG (ProductCost) 'Average Product Cost', SUM (ProductQuantProductPrice) 'Potential Lost Revenue' FROM Product;