select winner.competitionId, winner.eventId, winner.average winner, loser.average loser, winner.best, loser.best, loser.best-winner.best
from (select competitionId, eventId, average, best from Results where pos=1 and roundId in ('c','f') and average>0) winner,
(select competitionId, eventId, average, best from Results where pos=2 and roundId in ('c','f') and average>0) loser
where winner.competitionId = loser.competitionId
and winner.eventId = loser.eventId
order by loser.average-winner.average, loser.best-winner.best