BIS 345 MENTOR Think Big /bis345mentor.com BIS 345 MENTOR Think Big /bis345mentor.com | Page 20

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.