BIS 345 MENTOR Think Big /bis345mentor.com BIS 345 MENTOR Think Big /bis345mentor.com | Page 11

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: Build your SELECT statement by choosing the certain
clauses from the list below and putting the clauses in the correct
order:
SELECT City, Count(*)
ORDER BY 2
WHERE Count(*) > 1
SELECT Region, Count(*)
GROUP BY City
FROM tblCustomer
ORDER BY Count(*)
HAVING Count(*) > 1