Baselight
SELECT -- YEAR(s.start_date) as year
       t.name as team
       , p.name as player
       , SUM(mps.saves) as saves
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) >= 2020
      AND mps.saves > 0
GROUP BY 1, 2 
ORDER BY saves DESC
LIMIT 100
teamplayersaves
PalmeirasWeverton717
Atletico-MGEverson634
Aston VillaE. Martínez626
EvertonJ. Pickford601
Eintracht FrankfurtK. Trapp598
CorinthiansCássio596
1899 HoffenheimO. Baumann590
Atletico MadridJ. Oblak580
Real MadridT. Courtois578
AustinB. Stuver576
RB BragantinoCleiton563
Real SociedadÁlex Remiro544
Bayer LeverkusenL. Hrádecký539
SantosJoão Paulo539
Nashville SCJ. Willis535
LiverpoolAlisson Becker533
FluminenseFábio527
BolognaŁ. Skorupski522
River PlateF. Armani521
NantesA. Lafont516
Club Brugge KVS. Mignolet503
SC BragaMatheus496
Borussia DortmundG. Kobel495
GetafeDavid Soria490
Talleres CordobaG. Herrera487
OsasunaSergio Herrera486
West HamŁ. Fabiański473
FSV Mainz 05R. Zentner466
WolvesJosé Sá461
TwenteL. Unnerstall456
Paris Saint GermainG. Donnarumma451
LyonAnthony Lopes450
Atlanta United FCB. Guzan449
CuiabaWalter448
Stade Brestois 29M. Bizot444
AC MilanM. Maignan444
CadizJ. Ledesma443
Rosario CentralJ. Broun442
VeronaL. Montipò437
BarcelonaM. ter Stegen437
TorinoV. Milinković-Savić431
Orlando City SCP. Gallese428
GenkM. Vandevoordt425
Seattle SoundersS. Frei425
GoiasTadeu422
Philadelphia UnionA. Blake420
Union St. GilloiseA. Moris417
Racing ClubG. Arias416
FulhamB. Leno415
SassuoloA. Consigli409
GuimaraesBruno Varela407
LeedsI. Meslier406
Minnesota United FCD. St. Clair404
Manchester UnitedDavid de Gea400
Sparta RotterdamN. Olij392
New York Red BullsCarlos Coronel391
Manchester CityEderson389
VfL BochumM. Riemann386
RB LeipzigP. Gulácsi383
AntwerpJ. Butez380
Atletico ParanaenseBento377
Bayern MünchenM. Neuer375
VfL WolfsburgK. Casteels375
Athletic ClubUnai Simón373
LecceW. Falcone373
WaalwijkE. Vaessen371
ReimsY. Diouf367
CharlotteK. Kahlina366
ValenciaG. Mamardashvili366
JuventusW. Szczęsny365
FamalicaoLuíz Júnior365
Defensa Y JusticiaE. Unsain365
FC DallasM. Paes363
LilleL. Chevalier359
Union BerlinF. Rønnow357
Standard LiegeA. Bodart354
GentD. Roef353
NapoliA. Meret352
TottenhamH. Lloris352
Vasco DA GamaLéo Jardim352
FC PortoDiogo Costa346
FC AugsburgR. Gikiewicz343
FC CincinnatiR. Celentano343
GironaP. Gazzaniga342
ExcelsiorS. van Gassel340
UtrechtV. Barkas340
West HamA. Areola336
Fortaleza ECJoão Ricardo332
SevillaY. Bounou332
Colorado RapidsW. Yarbrough331
CharleroiH. Koffi329
Real Salt LakeZ. MacMath327
Inter MiamiD. Callender322
BahiaMarcos Felipe321
Manchester UnitedA. Onana320
Arsenal SarandiA. Medina319
MarseillePau López319
KV MechelenG. Coucke318
Sporting Kansas CityT. Melia317
GIL VicenteAndrew316

Share link

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