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 ;