select
    MEMBER_ID as ID,
    (SCORE1-SCORE2) as diff
FROM CONTEST_RESULTS
ORDER BY (SCORE1-SCORE2) desc, MEMBER_ID ASC;