Write a query to retrieve the player names and their respective teams' coach names for all players ordered by player$\_$name.

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