First to 3 runs (MLB)

[JT]

Hello,

Is there a way to see stats for which team scored 3 runs first within a given query?

For example, to see all favorites of -150 or bigger, how many times they ended up getting to 3 first, vs their opponent getting to 3 first, vs neither getting to 3.

Thanks,

JT

[Joe Meyer]

JT,

for free SDQL support, please use our discussion group at:
https://groups.google.com/forum/#!forum/SportsDataBase

Or just tweet it out using the hash tag #SDQL.

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 view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/23cd6c86-92c1-4a90-a883-cfd17426ae16n%40googlegroups.com.

[Gambrinus]

To see teams favored by at least -150 who scored at least 3 before their opponent scored:

• SF>=3 and line<-150

http://www.gimmethedog.com/MLB?q=SF%3E%3D3%20and%20line%3C-150

To see teams favored by at least -150 whose opponent scored at least 3 before they scored:

• o:SF>=3 and line<-150

http://www.gimmethedog.com/MLB?q=o%3ASF%3E%3D3%20and%20line%3C-150

To see teams favored by at least -150 who did not score 3 runs before the opponent scored, nor did the opponent open the game with 3 runs unanswered:

• SF<3 and o:SF<=3 and line<-150

http://www.gimmethedog.com/MLB?q=SF%3C3%20and%20o%3ASF%3C%3D3%20and%20line%3C-150

As my friend Joe says, SDQL is easy!

[JT]

Thanks for your response Gambrinus. I had looked into SF previously but that's not quite what I'm looking for. I am trying to find a query that includes all games where the favorite scored 3 runs prior to the other team scoring 3 runs. That would include games that were at a score of 1-1, 1-2, etc. prior to the favorite getting to 3.

Thanks