how many times in a single season all fav win in the same day??

79 views
Skip to first unread message

figue

unread,
May 24, 2023, 5:26:24 PM5/24/23
to SportsDataBase
favorites or undedors win all on the same day 

Gambrinus

unread,
May 27, 2023, 4:23:32 PM5/27/23
to SportsDataBase
fig,

It doesn't happen very often in MLB. The same SDQL will work in other sports. 
  • R(date),R(S(WF@date)),R(int(S(1@date)/2))@date and date<today | $1 as 'Date',$2 as 'FWs',$3 as '# of Games'@$2=$3 and $3>7

Join us at the GimmeTheDog on Discord for quicker answers to you SDQL questions. 

Gambrinus

unread,
May 27, 2023, 4:24:06 PM5/27/23
to SportsDataBase
Opps, forgot the Discord link. 

https://discord.gg/V5Yesxx7Ma

julio cesar garcia

unread,
May 27, 2023, 4:37:42 PM5/27/23
to sportsd...@googlegroups.com
Thanks for your answer. 

--
You received this message because you are subscribed to a topic in the Google Groups "SportsDataBase" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/sportsdatabase/mVmMdZkFZWk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to sportsdatabas...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/c74ead7f-a46d-4dc5-bb9d-7a336ad4136dn%40googlegroups.com.

Gambrinus

unread,
May 27, 2023, 4:42:07 PM5/27/23
to SportsDataBase
I forgot to mention the query only shows days where at least 8 games where played. Otherwise, there are tons of playoff dates where there's only a few games and the favorite won all of them. Remover the "  and $3>7" from the end or change the ">7" to something else to see.
Reply all
Reply to author
Forward
0 new messages