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