BIS 345 MENTOR Think Big /bis345mentor.com BIS 345 MENTOR Think Big /bis345mentor.com | Page 3

SELECT State, Count(*)
FROM CustomerTable
GROUP BY State;
SELECT CustomerID, Count(State)
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