Extra innings

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: