WHERE major = ' ' WHERE major IS NULL WHERE major = ' NULL '
8.( TCO 3) Which of the following statements would count the number of customers within each state?
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)