SDQL Question Please

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Roscoe_Word
    SBR MVP
    • 02-28-12
    • 3999
    #1
    SDQL Question Please
    Hello. Very new to this method and may I please ask: "What is the code to display a team's most recent games?"

    I know this code : "team and season = 2019 and site = away", but I don't know how to add only for last 2 games.

    I checked the manual, but couldn't find it.

    Was looking to see the teams stats, on the road, for only their last 2 games.

    Thanks very much.

    Roscoe
    Tags: None
    • nash13
      SBR MVP
      • 01-21-14
      • 1122
      #2
      team and season = 2019 and (site = away or p:site=away) this will give you the code if one of their last 2 games was an away game
      team and season = 2019 and (site = away and p:site=away) and this will combine both games as away games
      good luck
        Comment
        • Roscoe_Word
          SBR MVP
          • 02-28-12
          • 3999
          #3
          Originally posted by nash13
          team and season = 2019 and (site = away or p:site=away) this will give you the code if one of their last 2 games was an away game
          team and season = 2019 and (site = away and p:site=away) and this will combine both games as away games
          good luck
          Thank you, Nash. Appreciate the help.
            Comment
            • Getch13
              SBR Hall of Famer
              • 07-13-18
              • 6924
              #4
              NBA 1st.QT. by teams; A(P1) as '1Q PTS', A(o:P1) as 'Opp 1Q PTS', A(M1) as '1Q Margin'@team and site and season=2019

              NBA 1st Half by teams: A(P1+P2) as '1H PTS', A(o:P1+o:P2) as 'Opp 1H PTS', A(M2) as '1H Margin'@team and site and season=2019
                Comment
                • Roscoe_Word
                  SBR MVP
                  • 02-28-12
                  • 3999
                  #5
                  Thank you Nash and Getch for your help. I'm getting close.

                  I entered this team and season = 2019 and (site = away and p:site=away)

                  and got the following output.

                  It displays line stats for the last 1 away game for the Denver Nuggets and the Memphis Grizzlies.

                  It displays the last 2 away games for the Suns and Thunder (which is what I was looking for)

                  But then it displays the last 3 and more away games for the rest of the league.

                  Can I narrow the code to display only the last 2 away games for all the teams?

                  1 0-0-1 (0.00, 0.0%) -4.0 0-1-0 (-22.00, 0.0%) 200.0 1-0 (4.00, 100.0%) Nuggets
                  1 1-0-0 (3.50, 100.0%) 1.5 1-0-0 (14.50, 100.0%) 221.5 1-0 (2.00, 100.0%) Grizzlies
                  2 1-1-0 (2.50, 50.0%) 4.0 1-1-0 (1.50, 50.0%) 218.0 1-1 (-1.50, 50.0%) Suns
                  2 1-1-0 (-4.25, 50.0%) 6.8 2-0-0 (22.00, 100.0%) 215.0 0-2 (-11.00, 0.0%) Thunder
                  3 3-0-0 (18.33, 100.0%) -0.3 1-2-0 (-3.17, 33.3%) 227.8 3-0 (18.67, 100.0%) Timberwolves
                  3 3-0-0 (9.17, 100.0%) 9.8 0-3-0 (-5.83, 0.0%) 217.8 1-2 (-0.67, 33.3%) Knicks
                  3 2-1-0 (4.33, 66.7%) -2.7 2-1-0 (-4.67, 66.7%) 217.0 2-1 (7.00, 66.7%) Pacers
                  3 0-3-0 (-9.17, 0.0%) 0.5 1-2-0 (-8.00, 33.3%) 218.3 0-3 (-9.67, 0.0%) Pistons
                  3 0-3-0 (-6.17, 0.0%) 8.2 3-0-0 (18.50, 100.0%) 231.8 0-3 (-14.33, 0.0%) Pelicans
                  3 1-2-0 (1.00, 33.3%) 0.7 1-2-0 (-4.00, 33.3%) 219.0 1-2 (0.33, 33.3%) Mavericks
                  4 3-1-0 (3.62, 75.0%) 2.4 2-2-0 (-2.12, 50.0%) 219.4 2-2 (1.25, 50.0%) Bulls
                  4 0-4-0 (-11.62, 0.0%) -6.4 3-1-0 (10.50, 75.0%) 228.2 1-3 (-5.25, 25.0%) Clippers
                  4 1-3-0 (-3.25, 25.0%) 5.0 2-2-0 (-10.25, 50.0%) 218.0 1-3 (-8.25, 25.0%) Heat
                  4 2-2-0 (-3.25, 50.0%) 8.2 2-2-0 (-1.00, 50.0%) 215.5 1-3 (-11.50, 25.0%) Cavaliers
                  5 4-1-0 (9.40, 80.0%) 4.8 2-3-0 (-13.10, 40.0%) 218.5 3-2 (4.60, 60.0%) Raptors
                  5 3-2-0 (0.90, 60.0%) 4.5 3-2-0 (0.80, 60.0%) 207.2 1-4 (-3.60, 20.0%) Magic
                  5 2-2-1 (-8.10, 50.0%) -2.9 1-4-0 (-4.00, 20.0%) 234.8 2-3 (-5.20, 40.0%) Rockets
                  5 3-2-0 (0.80, 60.0%) -0.2 3-2-0 (9.70, 60.0%) 222.5 2-3 (1.00, 40.0%) Spurs
                  5 1-4-0 (-8.50, 20.0%) 1.5 2-3-0 (-1.20, 40.0%) 212.4 1-4 (-10.00, 20.0%) Jazz
                  5 2-3-0 (0.30, 40.0%) -5.3 1-4-0 (-4.60, 20.0%) 222.2 5-0 (5.60, 100.0%) Lakers
                  5 5-0-0 (6.20, 100.0%) 4.6 2-3-0 (-1.20, 40.0%) 218.4 2-3 (1.60, 40.0%) Kings
                  6 3-3-0 (-0.75, 50.0%) -1.2 1-4-1 (0.00, 20.0%) 215.5 2-4 (0.50, 33.3%) Seventysixers
                  6 2-4-0 (3.25, 33.3%) -6.4 3-3-0 (7.25, 50.0%) 224.1 5-1 (9.67, 83.3%) Bucks
                  6 3-2-1 (-2.42, 60.0%) 4.6 3-2-1 (2.50, 60.0%) 222.5 2-4 (-7.00, 33.3%) Nets
                  6 2-4-0 (-10.17, 33.3%) 11.5 5-1-0 (14.08, 83.3%) 225.6 1-5 (-21.67, 16.7%) Hawks
                  7 5-2-0 (7.14, 71.4%) 8.9 5-2-0 (11.86, 71.4%) 231.3 3-4 (-1.71, 42.9%) Wizards
                  7 3-4-0 (-6.14, 42.9%) 7.6 4-3-0 (-8.29, 57.1%) 224.3 2-5 (-13.71, 28.6%) Hornets
                  7 6-1-0 (7.57, 85.7%) -0.4 2-5-0 (-9.00, 28.6%) 215.3 4-3 (8.00, 57.1%) Celtics
                  8 6-2-0 (1.62, 75.0%) 9.5 5-3-0 (0.62, 62.5%) 220.5 2-6 (-7.88, 25.0%) Warriors
                  9 5-4-0 (-0.28, 55.6%) 3.1 4-5-0 (-1.67, 44.4%) 226.3 3-6 (-3.33, 33.3%) Trailblazers
                  Showing 1 to 30 of 30 entries
                    Comment
                    • nash13
                      SBR MVP
                      • 01-21-14
                      • 1122
                      #6
                      it summarizes them as instances on a seasonal basis.
                      the number 9 on the trailblazers tells you that they played 9 times a game back2back on the road so far.
                      i will look into the code later when i am back home
                        Comment
                        • Roscoe_Word
                          SBR MVP
                          • 02-28-12
                          • 3999
                          #7
                          Originally posted by nash13
                          it summarizes them as instances on a seasonal basis.
                          the number 9 on the trailblazers tells you that they played 9 times a game back2back on the road so far.
                          i will look into the code later when i am back home
                          Thank you.
                            Comment
                            • Getch13
                              SBR Hall of Famer
                              • 07-13-18
                              • 6924
                              #8
                              Roscoe this group may help you as well.

                              Redirecting to Google Groups
                              https://groups.google.com/forum/#!forum/sportsdatabase
                                Comment
                                • Roscoe_Word
                                  SBR MVP
                                  • 02-28-12
                                  • 3999
                                  #9
                                  Originally posted by Getch13
                                  Roscoe this group may help you as well.

                                  https://groups.google.com/forum/#!forum/sportsdatabase
                                  Thanks, Getch.
                                    Comment
                                    Previous template Next
                                    SBR Contests
                                    Collapse
                                    Contests Home
                                    MLB HR Derby
                                    Top-Rated US Sportsbooks
                                    Collapse
                                    Working...