Archery League Database design
You can create the following tables:


  Player, League, Match(with FK to league), Round(with FK to Match), Shot(with FK to round &amp; Player)


And the following N:N table


  PlayerLeague(a player subscribed to the league)


if the situation exists that a player  can subscribe to a league but doesn't participate in some matches, then another N:N table will be needed so you know to what matches the player has subscribed to

you can then sort the results by a query like

select 
 P.PlayerName,
 sum(S.Score),
 avg(S.Score)
from Shot S
inner join Player on P on S.PlayerID=P.PlayerID
group by P.PlayerName
order by sum(S.Score) desc


you can add extra joins/groupby's if you want to have a more detailed result grouped on league/match