Last Year's Super Bowl loser

[Facts]

Joe,

Any help on a query to pull up last year's super bowl loser so I can
run parameters on it? Something that would grab I guess 03-10, since
you have playoffs in there since 02. Thanks!

[Joe Meyer]

Facts,

please try a search of the group for 'superbowl'
and don't forget to address queries to the many SDQL experts here
as 'Friends,' or 'Experts,' or such (ie not `Joe,`).

Best wishes,

Joe Meyer

http://SportsDataBase.com

--
You received this message because you are subscribed to the Google Groups "SportsDataBase" group.
To post to this group, send email to sportsd...@googlegroups.com.
To unsubscribe from this group, send email to sportsdatabas...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/sportsdatabase?hl=en.

[Facts]

I searched and find only threads on the Super Bowl winner, such as
this one:

http://groups.google.com/group/sportsdatabase/browse_thread/thread/ee1d530fa21d57d4/5163135ce7a3f526?lnk=gst&q=superbowl#5163135ce7a3f526

There they were trying to get to the Super Bowl loser but never quite
got there.

I get how to find the SB winner, but still can't see the loser.
Thanks! And I'll address items to all next time - you're the guru
though!

[Joe Meyer]

 

Facts,

thank for the useful link.

I see that the super bowl winner was given by the SDQL:
R(W@team and playoffs=1) = 1
 
This is nice and short and says that the team's last playoff game was a win.

Unfortunately, this has the potential of giving false positives:
 If a super bowl winner doesn't even make the playoffs the following year then this SDQL will still qualify that team the subsequent year. 

Here is a better super bowl winner query:

To see how superbowl winners do in week one the following season use the SDQL:
R(W@team and season and playoffs=1)[team and season-1 and playoffs=1]  = 1

To get the super bowl loser I guess you have to move to using `week`:

R(L@team and season and week=22)[team and season-1 and week=22]  = 1 and week = 1

Square bracket notation can be intimidating:
It is handy and not hard for more see:

 

http://sportsdatabase.com/sdb.py/Manual/summative

 
Best wishes,

Joe Meyer

http://SportsDataBase.com

[Renkcub]

Joe, 

What does the "R" query represent? 

[weathe...@comcast.net]

replace

---

From: "Renkcub" <brendan...@gmail.com>
To: sportsd...@googlegroups.com
Sent: Monday, October 6, 2014 5:05:39 PM
Subject: Re: Last Year's Super Bowl loser

To unsubscribe from this group and stop receiving emails from it, send an email to sportsdatabas...@googlegroups.com.

To post to this group, send email to sportsd...@googlegroups.com.

Visit this group at http://groups.google.com/group/sportsdatabase.
For more options, visit https://groups.google.com/d/optout.