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 )