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