Assume you have a table with the following columns:( Points: 5) 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