WP>o:WP

16 views
Skip to first unread message

John Currey

unread,
Jul 1, 2022, 4:37:31 PMJul 1
to SDQL API
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'

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

Joe Meyer

unread,
Jul 3, 2022, 12:46:09 PMJul 3
to sdq...@googlegroups.com
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

unread,
Jul 3, 2022, 1:36:08 PMJul 3
to SDQL API

Joe Meyer

unread,
Jul 9, 2022, 4:07:01 PMJul 9
to sdq...@googlegroups.com
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


best regards,

Joe Meyer
Sports Database LLC


John Currey

unread,
Jul 13, 2022, 7:28:15 PMJul 13
to SDQL API
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

unread,
Jul 15, 2022, 9:20:18 AMJul 15
to sdq...@googlegroups.com
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

Reply all
Reply to author
Forward
0 new messages