Extra innings

93 views
Skip to first unread message

Joseph Aberasturi

unread,
Feb 4, 2023, 12:57:33 PM2/4/23
to SportsDataBase
Hello, what is the SDQL for extra innings in the previous game? Thank you

Joe Meyer

unread,
Feb 4, 2023, 3:06:14 PM2/4/23
to SportsDataBase

Joseph,

I see that both GimmeTheDog and AWang have the MLB parameter 'inning runs', which is a Python list.
To isolate extra inning games use the SDQL, check the length of that list with the Python builtin function `len`:
len(inning runs)>9

For extra innings in the previous game use the SDQL:
len(p:inning runs)>9

For inspecting lists, the Python builtin functions `max` and `min` are also handy.
To isolate games where the team scored at least 5 in a single inning use the SDQL:
max(inning runs)>=5

Best regards,

Joe Meyer
Sports Database LLC

Gambrinus

unread,
Feb 15, 2023, 6:03:03 PM2/15/23
to SportsDataBase
GimmeTheDog has the shortcut X for extra innings. 

This will show teams 2022 records and other cool info for 2022:
  • team and X and season=2022
https://www.gimmethedog.com/MLB?q=team%20and%20X%20and%20season%3D2022
Reply all
Reply to author
Forward
0 new messages