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
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