BIS 345 MENTOR Keep Learning /bis345mentor.com BIS 345 MENTOR Keep Learning /bis345mentor.com | Page 10

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)
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:
CustID (PK)
LastNameFirstNamePhoneCityRegionOverdue
Status*PreferredIncomeNumOrdersBalanceBirthdate
10
SmithBob123-4567OrlandoNorth
Paid
Y1000051001/1/1978
12RamirezJose422-1234ApexSouthPaidY50000166002/8/1970
13WashingtonTerrell951-
1234SujourEast[null]Y20000257003/5/1985
15JonesBill963-
7894AxeCrossingWestUnpaidY16900250012/1/1990
17MoralesSandy951-
1234OrlandoNorthPaidN85000904008/3/1986
21PrincipeMichelle963-
4561ApexSouthPaidN94000853007/2/1974
23MavisJohn147-
4561SujourEastUnpaidY25000266003/5/1989
*Overdue Status indicates customers with a balance that is 30
or more days overdue