Winning Streak Code?

[johnh...@hotmail.com]

I was experimenting just to see how teams fared in their attempt to win 23 in a row as a home favorite in college foots. I have this code but I see it is generating multiple instances of the same team after winning 22 in a row. For example, see the multiple hits on teams like Alabama, USC, etc. in this query. How would I further isolate the code to only show the very first instance of a team trying to win their 23rd in a row in a particular winning streak? Yes, this code should be active with Georgia today.

HF and S(margin>0@team, N=22)=22 

[johnh...@hotmail.com]

Anyone??

[Joe Meyer]

John and SDQL Friends,

to see how teams fared in their attempt to win 23 in a row as a home favorite use the SDQL:

date,team,margin,S(W),S(L)@Streak(margin>0@team and HF, N=22)=22 and HF 

https://s3.sportsdatabase.com/NCAAFB/query.html?sdql=date%2Cteam%2Cmargin%2CS%28W%29%2CS%28L%29%40Streak%28margin%3E0%40team+and+HF%2C+N%3D22%29%3D22+and+HF&submit=++S+D+Q+L+%21++

 

best regards,

Joe Meyer

Eyeball Communications LLC

On Sat, Oct 7, 2023 at 3:23 AM johnh...@hotmail.com <johnh...@hotmail.com> wrote:

I was experimenting just to see how teams fared in their attempt to win 23 in a row as a home favorite in college foots. I have this code but I see it is generating multiple instances of the same team after winning 22 in a row. For example, see the multiple hits on teams like Alabama, USC, etc. in this query. How would I further isolate the code to only show the very first instance of a team trying to win their 23rd in a row in a particular winning streak? Yes, this code should be active with Georgia today.

HF and S(margin>0@team, N=22)=22 

--
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/7bd3feeb-d5f6-4b28-a917-4acb803654e5n%40googlegroups.com.

[Daniel NYC]

Joe how do you isolate a team in this example:

date,start time, week, site,team, money line,o:money line,o:team,line, o:line, total@team and season= 2023 and week< 7 |

Let's say I only wanted to see the Chiefs games this season.

[Joe Meyer]

Daniel and SDQL Friends,

to isolate that on the Chiefs, use the SDQL:

date,start time, week, site,team, money line,o:money line,o:team,line, o:line, total@team='Chiefs' and season= 2023 and week< 7 |

Best regards.

Joe Meyer

Eyeball Communications LLC

To view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/f3a22563-590b-42e1-b0f3-03131115d9abn%40googlegroups.com.