Competitor   Points
1            1
1            2
1            3
2            6
2            7
2            8
3            8

Pos.  Competitor  Total
1     2           15
2     3           8
3     1           5

create table #temp
(
	competitor int,
	points int
)
 
create table #results
(
	pos int identity(1,1),
	competitor int,
	total int
)

insert #temp ( competitor, points )
	select 1, 1 union
	select 1, 2 union
	select 1, 3 union
	select 2, 6 union
	select 2, 7 union
	select 2, 8 union
	select 3, 8

insert #results ( competitor, total )
	select competitor, sum(points)
	from #temp t
	where not exists (
		select 1
		from #temp
		where competitor = t.competitor and points > t.points
		group by competitor
		having count(*) > 1 ) 
	group by competitor
	order by sum(points) desc

select * from #results