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