Write a SQL query to find the "player$\_$name", "country" & "runs$\_$scored" of players who have scored more than $5000$ runs. Rank the players based on their "runs$\_$scored" in descending order, and assign the rank as "Top Scorer, $"$ "High Scorer, $"$ or "Moderate Scorer" based on the following conditions: "Top Scorer": Rank $1.$ "High Scorer": Rank $2$ to $5($inclusive$).$ "Moderate Scorer": Rank $6$ and above.

Tables Schema as Below:

CricketPlayer

columnName dataType

player$\_$id INTEGER

player$\_$name TEXT

country TEXT

batting$\_$style TEXT

bowling$\_$style TEXT

matches$\_$played INTEGER

runs$\_$scored INTEGER

wickets$\_$taken INTEGER

batting$\_$average DECIMAL$(5,2)$

bowling$\_$average DECIMAL$(5,2)$

Team

columnName dataType

team$\_$id INTEGER

team$\_$name TEXT

country TEXT

coach TEXT

captain TEXT

player$\_$id INTEGER

Input