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 : 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