BIS 345 MENTOR Extraordinary Success /bis345mentor.com BIS 345 MENTOR Extraordinary Success /bis345mentor | Page 18

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.
37. (TCO 3) 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 name of the city, and the number of
customers in that city. Include only those cities that have more than 1
customer in them. Order the data by city in descending order.
tblCustomer:
Part 1:
SELECT City, COUNT(*) FROM tblCustomer