N=10

[John Currey]

Something seems wrong here:

• date,team,o:team,game number,tS(ats margin<0,N=10)*1,tS(ats margin>0,N=10)*1,tS(ats margin=0,N=10)*1@season=2023 and conference='SEC'
  

https://s3.sportsdatabase.com/NCAAFB/query.html?sdql=date%2Cteam%2Co%3Ateam%2Cgame+number%2CtS%28ats+margin%3C0%2CN%3D10%29*1%2CtS%28ats+margin%3E0%2CN%3D10%29*1%2CtS%28ats+margin%3D0%2CN%3D10%29*1%40season%3D2023+and+conference%3D%27SEC%27&submit=++S+D+Q+L+%21++

Notice Vanderbilt shows zero for ats wins, ats losses and ats pushes in week 1 of 2023, while Mississippi State shows 3-7-0 in week 1. In week 2 on 9/2, VAN shows 2-8-0 ats over its last 10. I'm trying to understand why some teams show zeroes in week 1, but weeks 2 and after seem correct. 

Then ats margins look good for VAN. 

https://s3.sportsdatabase.com/NCAAFB/query.html?sdql=date%2Cteam%2Co%3Ateam%2Cats+margin%40team%3D%27VAN%27+and+20220901%3Cdate%3Ctoday&submit=++S+D+Q+L+%21++

[Joe Meyer]

John and SDQL API Friends,

to get results for each team separately you need to group by team. 

Like this:

date,team,o:team,game number,S(ats margin<0,N=10)*1,S(ats margin>0,N=10)*1,tS(ats margin=0,N=10)*1@season=2022 and conference='SEC' and team|

 

best regards,

Joe Meyer

Eyeball Communications LLC

--

---
You received this message because you are subscribed to the Google Groups "SDQL API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sdqlapi+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sdqlapi/3c02a55f-03e0-4757-b6ec-a3fb2b86c5a9n%40googlegroups.com.