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