22>soccerPlayers

You have a table soccer_team that contains information about the players in your favorite soccer team. This table has the following structure: id: the unique ID of the player; first_name: the first name of the player; surname: the last name of the player; player_number: the number that the player wears (the number is guaranteed to be unique). Create a semicolon-separated list of all the players, sorted by their numbers, and put this list in a table under a column called players. The information about each player should have the following format: first_name surname #number.

code>>

/*Please add ; after each select statement*/

CREATE PROCEDURE soccerPlayers()

BEGIN

SELECT group_concat(concat(first_name," ", surname, " #", player_number) order by player_number SEPARATOR '; ') as players from soccer_team;

END