Short Cuts¶
SDQL short cuts save on typing and make queries more readable.
single letter¶
The SDQL provides single letter short cuts for common parameters.
- H the team is at home
- A the team is away
- W the team won
- L the team lost
- F the team is favored to win
- D the team is the underdog
- O the game went over the projected total
- U the game went under the projected total
- C the team and opponent are in the same conference.
Single letter short cuts can be strung together: H and W and F is the same as HWF.
- To see the Average margin for home dogs after winning as an away dog, use the SDQL:
- A(points-o:points) @ HD and p:WAD
summative¶
Summative short cuts are also addressed in Summative.
- tA the team’s season to date average
- tS the team’s season to date sum
- oA the opponent’s season to date average
- oS the opponent’s season to date sum
- tpA the team’s average last season
- tpS the team’s sum last season
- opA the opponent’s average last season
- opS the opponent’s sum last season
- tp2A the team’s average two seasons back
- tp2S the team’s sum two seasons back
- op2A the opponent’s average two seasons back
- op2S the opponent’s sum two seasons back
The pattern continues so that summative stats from any past season can be accessed.
For baseball, the corresponding shortcuts for starters are: sA, sS, spA, spS, and so on.
- To see how NFL teams have done in week 1 when their average points had increased over the past three seasons, use the SDQL:
- tp3A(points)<tp2A(points)<tpA(points) and week=1
Python automatically casts Booleans as integers inside of summatives.
- To see the against-the-spread record of each NBA team for the 2016 season, use the SDQL:
- tS(points+line>o:points) as ‘ATSW’,tS(points+line<o:points) as ‘ATSL’@team and season=2016
