winning streak query

Chris M

unread,

Sep 5, 2021, 8:03:19 PM9/5/21

to SportsDataBase

how do i query for a team that has won 5 or more games in a row at the new site ?

jerel....@gmail.com

unread,

Sep 5, 2021, 8:17:22 PM9/5/21

to SportsDataBase

I think you might want something like this:

date,team,o:team,points,o:points@season=2020 and streak>=5

Chris M

unread,

Sep 6, 2021, 4:27:18 PM9/6/21

to SportsDataBase

Didn't work I just get this "('season=2020', 'season=2020', 'season=2020'), (' and ', ' and ', ' and '), ('streak>=5', 'streak>=5', 'streak>=5'))dateteamo:teampointso:points
20210617
Team1
Team2
999
999
20210617"

Team2
Team1
999
999

Jerel Novick

unread,

Sep 6, 2021, 7:27:16 PM9/6/21

to sportsd...@googlegroups.com

What league are you trying to use it on? I have attached a screen print of what I get for the NFL and also the url.

https://s3.sportsdatabase.com/NFL/query.html?sdql=date%2Cteam%2Co%3Ateam%2Cpoints%2Co%3Apoints%40season%3D2020+and+streak%3E%3D5&submit=++S+D+Q+L+%21++

--
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/405b96a9-82c2-45a3-ab3d-c3351a996705n%40googlegroups.com.

Screen Shot 2021-09-06 at 7.22.49 PM.png

Chris M

unread,

Oct 13, 2021, 9:15:51 AM10/13/21

to SportsDataBase

so as not to start a new thread whats the new code for winning percentage. I tried @WP=0 and got no returns

Reply all

Reply to author

Forward