MLB Team Records when Leading after 6th Inning and Leading after 8th Inning

[Thomas Powe]

Guys/Gals,

Hope y'all doing well today!  I have an excel File that I made to keep up with Statistics on my Favorite team, "The Bipolar Braves of Atlanta".  

Wondering if you knew of any website that had the following stats:

• MLB Team Records when leading after the 6th Inning
• MLB Team Records when leading after the 8th Inning

Any help would be greatly appreciated.

Regards,
Thomas

[Joe Meyer]

Thomas,

bonus points for sex-neutral greeting!

The SDQL can easily handle anything like that.

To see how many time this season each team was winning after 6 use the SDQL:

Sum( sum(inning runs[:6]) > sum(o:inning runs[:6]) ) as 'Winning after 6'@ team and season=2014

All thoSe sums might look strange.

The outer Sum is picked up by the SDQL and instantiates a result column of type Sum.

In this case the Sum counts the number of time the team was winning after 6.

The parameter 'inning runs' is a Python list and `sum` is a built-in Python function.

Python lists can be split using a handy square bracket notation and this:

inning runs[:6]

gives a list of the runs scored in the first 6 innings.

The '@' sign starts the conditional clause ( like SQL's WHERE).

Here we group by team and restrict the season to 2014 with the SDQL:

@team and season = 2014

Best wishes,

Joe Meyer

http://SportsDatabase.com

--
You received this message because you are subscribed to the Google Groups "SportsDataBase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sportsdatabas...@googlegroups.com.
To post to this group, send email to sportsd...@googlegroups.com.
Visit this group at http://groups.google.com/group/sportsdatabase.
For more options, visit https://groups.google.com/d/optout.

[bur char]

Shouldn't this do it at KS.

M6>0 and team and season=2014

http://killersports.com/mlb/query?output=default&sdql=M6%3E0+and+team+and+season%3D2014&submit=++S+D+Q+L+!++

[Thomas Powe]

Thanks Y'all!