list . Order the rows in alphabetical order of city . Be sure to give the calculated columns an alias .
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
Part 1 : Write the complete SQL statement needed to return the rows that meet these requirements .