You store your business information in a SQL Server database. You want to produce a report about the available inventory in the following format CategoryID, ProductName, UnitsInStock, UnitPrice, Cost. The Cost column should contain the cost of all products per category and the total cost of all products in all categories must be included in the report. Which of the following queries will produce the required report?

You store your business information in a SQL Server database. You want to produce a report about the available inventory in the following format CategoryID, ProductName, UnitsInStock, UnitPrice, Cost. The Cost column should contain the cost of all products per category and the total cost of all products in all categories must be included in the report. Which of the following queries will produce the required report?

You store your business information in a SQL Server database. You want to produce a report about the available inventory in the following format CategoryID, ProductName, UnitsInStock, UnitPrice, Cost. The Cost column should contain the cost of all products per category and the total cost of all products in all categories must be included in the report. Which of the following queries will produce the required report?


Answer: – SELECT CategoryID, ProductName, UnitsInStock, UnitPrice, Cost = UnitPrice * UnitsInStock FROM Products ORDER BY CategoryID COMPUTE SUM (UnitPrice * UnitsInStock) BY CategoryID COMPUTE SUM (UnitPrice * UnitsInStock)

(When used with BY, the COMPUTE clause generates control-breaks and subtotals in the result set—not specified for this report.)