Player data

23 views
Skip to first unread message

John Currey

unread,
May 25, 2022, 7:08:06 PMMay 25
to SDQL API
I'm trying to filter by player data. I'd like to see pitchers that have pitched more than 40 innings (as of today, 5/25/2022). I may be missing something, but this is failing.
  • R(s:date),R(starter),S(Starter:list:innings pitched[-1])@starter and season=2022 and S(Starter:list:innings pitched[-1])>40

Thanks.

Joe Meyer

unread,
May 26, 2022, 4:58:56 PMMay 26
to sdq...@googlegroups.com
John and SDQL Friends,

Your SDQL returns the sum of starter innings pitched in 2022 after the sum of starter innings pitched since the start of the database is more than 40.

You can see how many innings in excess of 40 starters have using the SDQL:
R(starter),S(Starter:sum:IP)@starter and season=2022 and sS(Starter:sum:IP)>40|

Remember that sS(PARAMETER) expands out to S(PARAMETER@starter and season). 

Consider also the SDQL:
R(starter),S(Starter:sum:IP)@starter and season=2022|$1,$2@$2>40| 

best regards,

Joe Meyer


--

---
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/b37a68bb-1f27-47e9-8b56-278bfe77b48fn%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages