(Solved): want this one in sql A number of teams need to select their players. The rules of player selection ...

want this one in sql

A number of teams need to select their players. The rules of player selection are: - A player is eligible to play on a team if the first letters of the team and the player's name match. - Each team is assigned an avg_age, the maximum allowed average age of players on the team. - Players are selected while the average age of the players is less than or equal to the team's avg age. For each team that has players, return team name, number of players in ascending order of team name. Each team should select the maximum possible number of players.