Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 12.4 ms
Record Count: 11
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 = '9637'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
13092512.3611011227200214Tor2014
2603203003000030Tor2015
33663111.80645290010217400310Tor2016
44653314.090909130112620400330Tor2017
5157198.263158401427500190Tor2018
61201110.909091400384200110NYN2019
72782113.2380956016815000210Tor2019
83943411.588235100310818600340ChN2021
92992511.966006817100250ChN2022
103022711.18518510011168100252ChN2023
1178711.14285820016420070NYA2024
Mr. Sports

Marcus Stroman

Starting Pitcher
New York Yankees
Birthday: May 01, 1991   Age: 33
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2014 Tor 309 25 12.36 11 0 1 122 72 0 0
2015 Tor 60 3 20.00 3 0 0 30 0 0 0
2016 Tor 366 31 11.81 9 0 0 102 174 0 0
2017 Tor 465 33 14.09 13 0 1 126 204 0 0
2018 Tor 157 19 8.26 4 0 1 42 75 0 0
2019 Tor-NYN 120 11 10.91 4 0 0 38 42 0 0
2019 Tor-NYN 278 21 13.24 6 0 1 68 150 0 0
2021 ChN 394 34 11.59 10 0 3 108 186 0 0
2022 ChN 299 25 11.96 6 0 0 68 171 0 0
2023 ChN 302 27 11.19 10 0 1 116 81 0 0
2024 NYA 78 7 11.14 2 0 0 16 42 0 0