Given the goals chart for a football season, your task is to find the players with the highest goals per team.
Input
The Goals table will have 4 columns: player, team, goals_scored, played. Each player would appear only once in the table.
Output
Find the players with the highest number of goals based on goals_scored per team. There can be many players who scored the highest number of goals. Print all the players first order by the team name and then the player name.
If there are multiple players within a team who scored highest number of goals; print all of them.
Sample
input
Goals
| player (TEXT) | team (TEXT) | goals_scored (BIGINT) | played (BIGINT) |
|---|---|---|---|
| Iago Aspas | Celta Vigo | 14 | 33 |
| Antoine Griezmann | Barcelona | 13 | 36 |
| Luis Suarez | Atletico Madrid | 21 | 32 |
| Gerard Moreno | Villarreal | 23 | 33 |
| Karim Benzema | Real Madrid | 23 | 34 |
| Lionel Messi | Barcelona | 30 | 35 |
| Youssef En-Nesyri | Sevilla | 18 | 38 |
| Alexander Isak | Real Sociedad | 17 | 34 |
output
Goals
| player (TEXT) | team (TEXT) | goals_scored (BIGINT) | played (BIGINT) |
|---|---|---|---|
| Luis Suarez | Atletico Madrid | 21 | 32 |
| Lionel Messi | Barcelona | 30 | 35 |
| Iago Aspas | Celta Vigo | 14 | 33 |
| Karim Benzema | Real Madrid | 23 | 34 |
| Alexander Isak | Real Sociedad | 17 | 34 |
| Youssef En-Nesyri | Sevilla | 18 | 38 |
| Gerard Moreno | Villarreal | 23 | 33 |