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