Player data

[John Currey]

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

https://s3.sportsdatabase.com/MLB/query.html?sdql=R%28s%3Adate%29%2CR%28starter%29%2CS%28Starter%3Alist%3Ainnings+pitched%5B-1%5D%29%40starter+and+season%3D2022+and+S%28Starter%3Alist%3Ainnings+pitched%5B-1%5D%29%3E40&submit=++S+D+Q+L+%21++

Thanks.

[Joe Meyer]

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.