Loading...Loading chart...
1SELECT -- YEAR(s.start_date) as year
2       t.name as team
3       , p.name as player
4       , SUM(mps.saves) as saves
5FROM @blt.ultimate_soccer_dataset.match_player_stats mps
6     INNER JOIN @blt.ultimate_soccer_dataset.matches m on (mps.match_id = m.match_id)
7     INNER JOIN @blt.ultimate_soccer_dataset.players p on (mps.player_id = p.player_id)
8     INNER JOIN @blt.ultimate_soccer_dataset.teams t on (mps.team_id = t.team_id)
9     INNER JOIN @blt.ultimate_soccer_dataset.seasons s on (m.season_id = s.season_id)
10     INNER JOIN @blt.ultimate_soccer_dataset.competitions c on (s.competition_id = c.competition_id)
11WHERE YEAR(s.start_date) >= 2020
12      AND mps.saves > 0
13GROUP BY 1, 2 
14ORDER BY saves DESC
15LIMIT 100