How many times in a season does all 9 players get a single hit

[Adam B]

Hi all,

I have an over/under bet with a buddy of mine and neither of us can figure out the query for SDQL. we are looking to find out how many times last season in MLB a single team had each of their players record at least 1 hit. Could someone help us with the query? There is a bunch of beer and more importantly, bragging rights on the line.

Thank you in advance for the help

[Joe Meyer]

Adam and SDQL Friends,

To see a list of hits for batters in yesterday's games, use the SDQL: 

Batter:list:hits@date=today-1

Can you take it from there?

Hint: Python's list comprehension is handy.

Best regards,

Joe Meyer

SportsDatabase.com

eyeball communications llc

--
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/d9a120c9-d3eb-401e-ae5a-3506f3bb1cebn%40googlegroups.com.

[Adam B]

Joe that is perfect. Thank you for your help.

[Gambrinus]

Here ya go Adam. It happened once in 2022. If you won the bet, you owe me a beer. 😎

• date,team,o:team,Batter:list:name,Batter:list:hits@all(num==1 for num in Batter:list:hits)=1 and season=2022

https://www.gimmethedog.com/MLB?q=date%2Cteam%2Co%3Ateam%2CBatter%3Alist%3Aname%2CBatter%3Alist%3Ahits%40all(num%3D%3D1%20for%20num%20in%20Batter%3Alist%3Ahits)%3D1%20and%20season%3D2022