Next Opponent Ranked Code?

[johnh...@hotmail.com]

I tried searching here but could not find code I was hoping to find so would like to ask for help. What would the SDQL code look like if I wanted to see how an NCAA football team fairs in their game prior to playing a ranked team? For example, Tennessee plays at LSU this weekend and has Alabama on deck at home next weekend....thanks in advance for any help!

[johnh...@hotmail.com]

More specifically, I'd like to see how Josh Heupel coached teams have done in games prior to playing a ranked opponent. Thanks!

[John Dickey]

Current and next opponent/rank.

Key here is “no” for next opponent.

coach=Josh Heupel and no:rank>0 and o:team and no:team and no:rank

--
You received this message because you are subscribed to the Google Groups "SportsDataBase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sportsdatabas...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/035fe0d2-f356-49d5-b6e7-a9bb61ca9b2cn%40googlegroups.com.

[John Dickey]

You might like this output format at-a-glance better…

team, o:team, no:team, no:rank@coach=Josh Heupel and no:rank>0

JD

On Tue, Oct 4, 2022 at 7:26 PM johnh...@hotmail.com <johnh...@hotmail.com> wrote:

--

[johnh...@hotmail.com]

Thank you!