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