Summative issue with doubleheaders

7 views
Skip to first unread message

John Currey

unread,
Jun 23, 2022, 5:52:17 PMJun 23
to SDQL API
Hi,

This shows Dodger games in 2022 where they won 3 straight games using the p: method to locate the games. 
  • date,team,o:team,margin>0@p:W and p2:W and p3:W and team=Dodgers and season=2022

This shows Dodger games in 2022 where they won 3 straight games using the summative method to locate the games. 

    In theory, the results of the 2 queries should be the same. The difference is the summative method missed the 5/17 game.

    This shows all Dodger games for 2022. On 5/17, the Dodgers swept a doubleheader and the win made the Dodgers 3 games into a 7-game win streak. It seems the summative missed game 2. 

    https://s3.sportsdatabase.com/MLB/query.html?sdql=date%2Cteam%2Co%3Ateam%2Cmargin%3E0%40team%3DDodgers+and+season%3D2022&submit=++S+D+Q+L+%21++

    Thanks. 

    Joe Meyer

    unread,
    Jun 25, 2022, 2:15:32 PMJun 25
    to sdq...@googlegroups.com
    John and SDQL API Friends,

    this is now working correctly.

    The only time 
    tS(W,N=3)=3

    would yield a different result than
    p:W and p2:W and p3:W

    is if runs is None for one of the 3 previous games as Aggregators skip over None.

    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/01bb248a-ef09-4947-9ffa-0e8bc8b1311en%40googlegroups.com.
    Reply all
    Reply to author
    Forward
    0 new messages