Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 6.46 ms
Record Count: 7
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 = '10098'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
13074.2857140000300007Mil2018
2246357.028571660030156001817Mil2019
372126100144800111Mil2020
43252811.607142100169412600262Mil2021
5191228.681818600448700211Mil2022
6212239.217391700647800212Mil2023
724640000240060NYN2024
Mr. Sports

Adrian Houser

Starting Pitcher
New York Mets
Birthday: February 02, 1993   Age: 31
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2018 Mil 30 7 4.29 0 0 0 0 30 0 0
2019 Mil 246 35 7.03 6 0 0 30 156 0 0
2020 Mil 72 12 6.00 1 0 0 14 48 0 0
2021 Mil 325 28 11.61 10 0 16 94 126 0 0
2022 Mil 191 22 8.68 6 0 0 44 87 0 0
2023 Mil 212 23 9.22 7 0 0 64 78 0 0
2024 NYN 24 6 4.00 0 0 0 0 24 0 0