Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 17.5 ms
Record Count: 6
Cached: No
Lazy: No
SQL:
SELECT ptsR=SUM(feeds.scored_points),
gmsR=SUM(feeds.games),
ppgR=(convert(real,SUM(feeds.scored_points)) / convert(real,SUM(feeds.games))),
wR=SUM(feeds.wins),
sR=SUM(feeds.saves),
cgR=SUM(feeds.complete_game),
wsbR=SUM(feeds.ws_points),
nwsR=SUM(feeds.nws_points),
nohR=SUM(feeds.no_hitter),
pfgR=SUM(feeds.perfect_game),startR=sum(feeds.starts),
reliefR=sum(feeds.relief),proteam,year=substring(period,1,4)
from feeds
WHERE player = '10858'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
12546.25100690022ChN2019
24567.51008270042ChN2020
32322985134013200218ChN2021
42655.21004120005ChN2022
5359576.29824542220447500057ChN2023
666164.12513081800016ChN2024
Mr. Sports

Adbert Alzolay

Relief Pitcher
Chicago Cubs
Birthday: March 01, 1995   Age: 29
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2019 ChN 25 4 6.25 1 0 0 6 9 0 0
2020 ChN 45 6 7.50 1 0 0 8 27 0 0
2021 ChN 232 29 8.00 5 1 3 40 132 0 0
2022 ChN 26 5 5.20 1 0 0 4 12 0 0
2023 ChN 359 57 6.30 2 22 0 44 75 0 0
2024 ChN 66 16 4.13 1 3 0 8 18 0 0