current season 5 inning results query

100 views
Skip to first unread message

J H

unread,
Apr 19, 2022, 1:41:23 PMApr 19
to SportsDataBase
I'm looking to find the game by game 5 inning results for this season, any help with a query would be great!

Gambrinus

unread,
Apr 19, 2022, 3:31:12 PMApr 19
to SportsDataBase
This shows the Yankees are away favorites are 81-66-177 straight up after 5 innings in the history of the database and 1-1-1 straight up this season in that situation.

Good luck.

Apr19.PNG

J H

unread,
Apr 19, 2022, 4:03:20 PMApr 19
to SportsDataBase
thanks for the reply.  I need it in game by game list form, so I can get the average runs scored and runs allowed per 5 innings as well as the standard deviation of these runs

not sure if sportsdatabase will give standard deviation and average for the current season.  IF so that would be ideal.  appreciate your help

Gambrinus

unread,
Apr 19, 2022, 4:15:55 PMApr 19
to SportsDataBase
How about this? You can definitely to the standard deviation and average, but I'm not clear on what you want. 
  • tS(sum(inning runs[:5])) as 'runs in 1st 5',tS(sum(o:inning runs[:5])) as 'o:runs in 1st 5',tS(sum(inning runs[:5])>sum(o:inning runs[:5])) as 'F5W',tS(sum(inning runs[:5])<sum(o:inning runs[:5])) as 'F5L',tS(sum(inning runs[:5])=sum(o:inning runs[:5])) as 'F5P'@team and season=2022

J H

unread,
Apr 19, 2022, 4:43:11 PMApr 19
to SportsDataBase
I don't get anything with the link provided.  What I'm looking for is the current season team by team average and standard deviation runs scored and runs allowed for the 1st 5 innings.

Gambrinus

unread,
Apr 19, 2022, 8:54:54 PMApr 19
to SportsDataBase
I get this:

Apr19a.PNG

J H

unread,
Apr 20, 2022, 3:28:50 PMApr 20
to SportsDataBase
Can it be broken down into games, so for Diamondbacks we would see a list of their games this season 5inning results?

I want to be able to get the standard deviation

Gambrinus

unread,
Apr 20, 2022, 6:31:21 PMApr 20
to SportsDataBase
What about this?
  • date,team,o:team,S5,o:S5@team=Diamondbacks and season=2022 and date<today
Reply all
Reply to author
Forward
0 new messages