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
Y1000051001 / 1 / 1978 12RamirezJose422-1234ApexSouthPaidY50000166002 / 8 / 1970