Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 6.53 ms
Record Count: 4
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 = '10860'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
187352.485714211046300035Det2021
2201702.87142858001011100070Det2022
3432666.54545457250644800066Det2023
446162.87502022400016Det2024
Mr. Sports

Alex Lange

Relief Pitcher
Detroit Tigers
Birthday: October 02, 1995   Age: 28
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2021 Det 87 35 2.49 1 1 0 4 63 0 0
2022 Det 201 70 2.87 8 0 0 10 111 0 0
2023 Det 432 66 6.55 7 25 0 64 48 0 0
2024 Det 46 16 2.88 0 2 0 2 24 0 0