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.