Baselight
SELECT p.name as player, t.name as team, s.season_label as season, c.name as competition, SUM(mps.goals_scored) as goals_scored
FROM @blt.ultimate_soccer_dataset.match_player_stats mps
     INNER JOIN @blt.ultimate_soccer_dataset.matches m on (mps.match_id = m.match_id)
     INNER JOIN @blt.ultimate_soccer_dataset.players p on (mps.player_id = p.player_id)
     INNER JOIN @blt.ultimate_soccer_dataset.teams t on (mps.team_id = t.team_id)
     INNER JOIN @blt.ultimate_soccer_dataset.seasons s on (m.season_id = s.season_id)
     INNER JOIN @blt.ultimate_soccer_dataset.competitions c on (s.competition_id = c.competition_id)
WHERE YEAR(s.start_date) >= 2016
      AND c.name IN ('Premier League', 'Primeira Liga')
GROUP BY player, team, season, competition
ORDER BY goals_scored DESC
LIMIT 5
playerteamseasoncompetitiongoals_scored
V. GyökeresSporting CP2024/2025Primeira Liga39
E. HaalandManchester City2022/2023Premier League36
B. DostSporting CP2016/2017Primeira Liga34
Jonas Gonçalves OliveiraBenfica2017/2018Primeira Liga34
Mohamed SalahLiverpool2017/2018Premier League32

Share link

Anyone who has the link will be able to view this.