BIS 345 Course Great Wisdom / tutorialrank.com BIS 345 Course Great Wisdom / tutorialrank.com | Page 39

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)
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