snizzal said:
Dr I was looking over some things this morning with Memphis....using the same logic as in the NFL when teams play tough d's like Pit, SF, Bal they have a hard time covering the following week. In my opinion Memphis is one of the top 3 defensive teams so I wanted to see how teams played following there game against Memphis and it seems most of the totals go over the following game. Would you help me with the SDQL on how I could verify this?
Good thinking!
This is what the SDQL needs -- thoughtful handicappers asking good questions.
To get all the games in which a team is off of Memphis, you need:
po:team=Grizzlies
The po prefix points the parameter following it to the team's previous opponent.
Of course, it would be useful to be able to drill down on this basic situation. For example, the team's rest is clearly important. Also, it might be interesting to query on the team's FGP against Memphis, whether they won or lost, the sites involved, whether the team is on a long road trip, et cetera. Happy hunting.
Dr M.