Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 6.24 ms
Record Count: 5
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 = '10894'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
1174189.666667500527200171LAA2019
295118.636364201185700110LAA2020
3126149509344200131LAA2021
42492410.3757014413500222LAA2023
53875.4285711004240070LAA2024
Mr. Sports

Griffin Canning

Starting Pitcher
Los Angeles Angels
Birthday: May 11, 1996   Age: 27
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2019 LAA 174 18 9.67 5 0 0 52 72 0 0
2020 LAA 95 11 8.64 2 0 1 18 57 0 0
2021 LAA 126 14 9.00 5 0 9 34 42 0 0
2023 LAA 249 24 10.38 7 0 1 44 135 0 0
2024 LAA 38 7 5.43 1 0 0 4 24 0 0