BIS 345 MENTOR Great Stories Here/bis345mentor.com BIS 345 MENTOR Great Stories Here/bis345mentor.com | Página 19

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.
Part 3: What function did you use to extract the three-digit exchange?
Why did you select this function? Rewrite the SQL using a different
function to extract these characters. (Points : 25)
Part 3: To extract the three-digit exchange I used the LEFT(Phone,3)
funcion.