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

upper case characters along with the exchange part of the
customer phone number (the first 3 digits). Include only
preferred customers in the 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.
Part 2: What rows will be returned from this query? List the
customer ID only of the rows to be returned.