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