WP>o:WP

[John Currey]

Hi,

I'm not sure why this is failing.

• date, team, o:team,(tA(p:margin>0@team and season)*100) as 'WP', (tA(op:margin>0@o:team and o:season)*100) as 'o:WP',site,line@HD and line>150 and season=2022 and (tA(p:margin>0@team and season)*100) as 'WP'>(tA(op:margin>0@o:team and o:season)*100) as 'o:WP'

https://s3.sportsdatabase.com/MLB/query.html?sdql=date%2C+team%2C+o%3Ateam%2C%28tA%28p%3Amargin%3E0%40team+and+season%29*100%29+as+%27WP%27%2C+%28tA%28op%3Amargin%3E0%40o%3Ateam+and+o%3Aseason%29*100%29+as+%27o%3AWP%27%2Csite%2Cline%40HD+and+line%3E150+and+season%3D2022+and+%28tA%28p%3Amargin%3E0%40team+and+season%29*100%29+as+%27WP%27%3E%28tA%28op%3Amargin%3E0%40o%3Ateam+and+o%3Aseason%29*100%29+as+%27o%3AWP%27&submit=++S+D+Q+L+%21++

None of the games in the output have a WP>o:WP. 

[Joe Meyer]

John and SDQL Friends,

I'm not sure what you are after here.

To isolate games where the team has a higher winning percentage than their opponent, use the SDQL condition:

tA(W)>oA(W) 

To see the win percentage of teams when they are playing a team with a lower win percentage, use the SDQL:

A(W)@tA(W)>oA(W) 

 

best regards

Joe Meyer

Sports Database 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/3847191c-393a-4818-9677-e0d494b67315n%40googlegroups.com.

[John Currey]

Thanks, that works, but what if I want to see the opponent's winning percentage at the time of each game?

https://s3.sportsdatabase.com/MLB/query.html?sdql=date%2Cteam%2Cwins%2Closses%2Co%3Ateam%2Co%3Awins%2Co%3Alosses%2CtA%28W%29*1%2CoA%28W%29*1%40season%3E%3D2022+and+team%3D%27Dodgers%27+and+date%3Ctoday+%7C&submit=++S+D+Q+L+%21++

[Joe Meyer]

John,

Do you parameters o:wins, o:losses give you what you want?

Otherwise, consider grouping by oS(W) and oS(L) and o:team, like this:

date,team,wins,losses,o:team,o:wins,o:losses@season>=2022 and team='Dodgers' and date<today and oS(W) and oS(L) and o:team

https://s3.sportsdatabase.com/MLB/query.html?sdql=date%2Cteam%2Cwins%2Closses%2Co%3Ateam%2Co%3Awins%2Co%3Alosses%40season%3E%3D2022+and+team%3D%27Dodgers%27+and+date%3Ctoday+and+oS%28W%29+and+oS%28L%29+and+o%3Ateam&submit=++S+D+Q+L+%21++

best regards,

Joe Meyer

Sports Database LLC

To view this discussion on the web visit https://groups.google.com/d/msgid/sdqlapi/8e51a319-991b-4eef-b659-c31bd6cdeac2n%40googlegroups.com.

[John Currey]

Yes, o:wins and o:losses do the trick for the opponent's winning percentage, but not the opponent's home and away winning percentages. 

[Joe Meyer]

John and SDQL Friends,

to get the H/A splits, just add a group for site, like this:

date,team,wins,losses,o:team,o:wins,o:losses@season>=2022 and team='Dodgers' and date<today and oS(W) and oS(L) and o:team and site

Best regards,

Joe Meyer

Sports Database LLC

To view this discussion on the web visit https://groups.google.com/d/msgid/sdqlapi/e848fda2-0681-4f93-be7a-30265ef6ff98n%40googlegroups.com.