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