current season 5 inning results query

J H

unread,

Apr 19, 2022, 1:41:23 PM4/19/22

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 PM4/19/22

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.

J H

unread,

Apr 19, 2022, 4:03:20 PM4/19/22

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 PM4/19/22

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

http://www.gimmethedog.com/MLB?q=tS(sum(inning%20runs%5B%3A5%5D))%20as%20%27runs%20in%201st%205%27%2CtS(sum(o%3Ainning%20runs%5B%3A5%5D))%20as%20%27o%3Aruns%20in%201st%205%27%2CtS(sum(inning%20runs%5B%3A5%5D)%3Esum(o%3Ainning%20runs%5B%3A5%5D))%20as%20%27F5W%27%2CtS(sum(inning%20runs%5B%3A5%5D)%3Csum(o%3Ainning%20runs%5B%3A5%5D))%20as%20%27F5L%27%2CtS(sum(inning%20runs%5B%3A5%5D)%3Dsum(o%3Ainning%20runs%5B%3A5%5D))%20as%20%27F5P%27%40team%20and%20season%3D2022

J H

unread,

Apr 19, 2022, 4:43:11 PM4/19/22

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 PM4/19/22

to SportsDataBase

I get this:

J H

unread,

Apr 20, 2022, 3:28:50 PM4/20/22

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 PM4/20/22

to SportsDataBase

What about this?

date,team,o:team,S5,o:S5@team=Diamondbacks and season=2022 and date<today

http://www.gimmethedog.com/MLB?q=date%2Cteam%2Co%3Ateam%2CS5%2Co%3AS5%40team%3DDiamondbacks%20and%20season%3D2022%20and%20date%3Ctoday

Reply all

Reply to author

Forward