BIS 345 Course Great Wisdom / tutorialrank.com BIS 345 Course Great Wisdom / tutorialrank.com | Page 4

FROM ProductTable GROUP BYProductID;

SELECT Average( UnitPrice) FROM ProductTable;

SELECT Avg( UnitPrice) FROM ProductTable;

None of the above

Question 9.9.( TCO 3) Which of the following statements would the extract the total value of all the orders?

Assume you have a table with the following columns:( Points: 5)

SELECT Total( OrderTotal) FROM OrderTable;

SELECT Sum( OrderTotal) FROM OrderTable;

SELECT Sum( OrderTotal) FROM OrderTable GROUP BY OrderTotal;

SELECT Rollup( OrderTotal) FROM OrderTable;