I want a query to rank the players in a table based on score (including tied ranks, tie breaker can be decided by username) and another query given a player name to return the two players above and below the given user with everyone's ranks (including the player in which the query is based).

I've attached an excel document with an example scenario and the required results.