: SELECT MV160840.FNAME, MV160840.LNAME, MV160840.CITY, MV160840.STATE, MV160840.CLASSHOA, As BROKEHOA, As ShotHOA FROM MV160840 WHERE ( CLASSHOA <> "" AND MV160840.ENTRY = 2 ) ORDER By BROKEHOA DESC