Count ()
34 . ( TCO 3 )________ functions are SQL mathematical summaries . ( Points : 5 ) Summation Summary Aggregate Cummalative
35 . ( TCO 5 ) When using the report server project wizard the most crucial step is _______. ( Points : 5 ) selecting your data source naming your project selecting the location to save your project selecting the correct template
36 . ( TCO 2 ) Refer to the tblCustomer table below . As a data analyst , you have been requested to select rows that meet the following requirements : For each city , list the city name in all upper case characters along with the exchange part of the customer phone number ( the first 3 digits ). Include only preferred customers in the list . Order the rows in alphabetical order of city . Be sure to give the calculated columns an alias .
tblCustomer : CustID ( PK )
LastNameFirstNamePhoneCityRegionOverdue Status * PreferredIncomeNumOrdersBalanceBirthdate 10
SmithBob123-4567OrlandoNorth Paid