Question 33.33.( TCO 3) Which of the following aggregate functions would not ignore null values.( Points: 5) Count AVG MAX Sum
Question 34.34.( TCO 3) Which of the following is not a valid aggregate function.( Points: 5) DATEDIFFERENCE COUNT MAX MIN
Question 35.35.( TCO 5) For the report server to use an extension, it must be ______.( Points: 5) configured linked to the server added to the report installed
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
Part 1: Write the complete SQL statement needed to return the rows that meet these requirements.
Part 2: What rows will be returned from this query? List the customer ID only of the rows to be returned.