Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 7.56 ms
Record Count: 10
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 = '9701'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
13292214.95454590111412000220NYN2014
24572915.75862140017614100290NYN2015
33052313.260876006218300221NYN2016
44533114.612904150117212600310NYN2017
55653317.121212100412433600330NYN2018
64993215.59375110313425500320NYN2019
71751214.583333400369900120NYN2020
82751518.3333347048611400150NYN2021
91491113.545455500544500110NYN2022
1076612.66666720020360060Tex2023
Mr. Sports

Jacob deGrom

Starting Pitcher
Texas Rangers
Birthday: June 19, 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
2014 NYN 329 22 14.95 9 0 1 114 120 0 0
2015 NYN 457 29 15.76 14 0 0 176 141 0 0
2016 NYN 305 23 13.26 6 0 0 62 183 0 0
2017 NYN 453 31 14.61 15 0 1 172 126 0 0
2018 NYN 565 33 17.12 10 0 4 124 336 0 0
2019 NYN 499 32 15.59 11 0 3 134 255 0 0
2020 NYN 175 12 14.58 4 0 0 36 99 0 0
2021 NYN 275 15 18.33 7 0 4 86 114 0 0
2022 NYN 149 11 13.55 5 0 0 54 45 0 0
2023 Tex 76 6 12.67 2 0 0 20 36 0 0