Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 7.38 ms
Record Count: 9
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 = '10144'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
1961.5000090051Pit2016
2303319.7741947006217100265Pit2017
33993112.87096814021609900310Pit2018
4237259.487015011700250Pit2019
571116.4545455200123900110Pit2020
6168237.304348404389000158NYN2021
7171295.89655162103011100920NYN2022
8224297.7241386004412000290Was2023
9107715.28571440034330070Was2024
Mr. Sports

Trevor Williams

Starting Pitcher
Washington Nationals
Birthday: April 25, 1992   Age: 32
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2016 Pit 9 6 1.50 0 0 0 0 9 0 0
2017 Pit 303 31 9.77 7 0 0 62 171 0 0
2018 Pit 399 31 12.87 14 0 2 160 99 0 0
2019 Pit 237 25 9.48 7 0 1 50 117 0 0
2020 Pit 71 11 6.45 2 0 0 12 39 0 0
2021 NYN 168 23 7.30 4 0 4 38 90 0 0
2022 NYN 171 29 5.90 2 1 0 30 111 0 0
2023 Was 224 29 7.72 6 0 0 44 120 0 0
2024 Was 107 7 15.29 4 0 0 34 33 0 0