Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 1.77 ms
Record Count: 13
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 = '8562'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
11661213.833333500447200120Was2010
264512.810012420050Was2011
33992814.25150014410500280Was2012
44042913.9310347018024900290Was2013
54613313.969697130016017100330Was2014
62732212.40909110001046900210Was2015
73272314.21739114001424500230Was2016
84432815.821428150116812000280Was2017
92782212.63636410011007800220Was2018
105003315.151515180117614400330Was2019
11020000000020Was2020
124458.810110240050Was2021
13010000000010Was2022
Mr. Sports

Stephen Strasburg

Starting Pitcher
Washington Nationals
Birthday: July 20, 1988   Age: 35
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2010 Was 166 12 13.83 5 0 0 44 72 0 0
2011 Was 64 5 12.80 1 0 0 12 42 0 0
2012 Was 399 28 14.25 15 0 0 144 105 0 0
2013 Was 404 29 13.93 7 0 1 80 249 0 0
2014 Was 461 33 13.97 13 0 0 160 171 0 0
2015 Was 273 22 12.41 10 0 0 104 69 0 0
2016 Was 327 23 14.22 14 0 0 142 45 0 0
2017 Was 443 28 15.82 15 0 1 168 120 0 0
2018 Was 278 22 12.64 10 0 1 100 78 0 0
2019 Was 500 33 15.15 18 0 1 176 144 0 0
2020 Was 0 2 0.00 0 0 0 0 0 0 0
2021 Was 44 5 8.80 1 0 1 10 24 0 0
2022 Was 0 1 0.00 0 0 0 0 0 0 0