Given a table GAMERS, pivot the table in such a manner that the Player is sorted in alphabetical order and displayed under its corresponding Role. Print NULL if no more players are associated with the corresponding role. The roles are Healer, Attacker, Defender, Tactician.
The description of the table GAMERS is given below:
NOTE : The output should contain 4 columns.
NOTE: You only need to implement the given function. Do not read input, instead use the arguments to the function. Do not print the output, instead return values as specified. Still have a question? Checkout Sample Codes for more details.