Active leaderboard in Google Sheets (Score)

I need help creating a leader board where H1-3 Is The first,second,third place in score from b1-9 and I1-3 is the name of the person from a1-9. can anyone help

1 Answer

try:

=QUERY(A1:B9, "select B,A order by B desc limit 3", 0)