BIS 345 MENTOR Keep Learning /bis345mentor.com BIS 345 MENTOR Keep Learning /bis345mentor.com | Page 3

FROM CustomerTable
GROUP BY CustomerID;
SELECT State, Count(CustomerID)
FROM CustomerTable;
None of the above.
9. (TCO 3) Which of the following statements would the extract
average income of the customers in each city? Assume you
have a table with the following columns:
(Points : 5)
SELECT City, Avg(Income)
FROM CustomerTable
GROUP BY City;
SELECT State, Avg(Income)
FROM CustomerTable
GROUP BY State;
SELECT City, Average(Income)
FROM CustomerTable
GROUP BY City;
SELECT State, Average(Income)
FROM CustomerTable
GROUP BY State;
10. (TCO 4) Query ______ is the complete process from
submission of a query to its actual execution. (Points : 5)
optimization
compilation
insertion
None of the above
11. (TCO 4) Assume you have two queries that must extract all
rows that have a value of greater than $100 in an Income
column. You are considering two ways of writing your WHERE
clause. The first option is to extract all columns that are NOT
less than or equal to $100. The second option is to extract all
columns that are greater than $100. Which option should you