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