SQL> select winner from superbowls; WINNER -------------------- Ravens Packers Packers Jets Chiefs Colts Cowboys Dolphins Dolphins Steelers Steelers WINNER -------------------- Raiders Cowboys Steelers Steelers Raiders 49ers Redskins Raiders 49ers Bears Giants WINNER -------------------- Redskins 49ers 49ers Giants Redskins Cowboys Cowboys 49ers Cowboys Packers Broncos WINNER -------------------- Broncos Rams Ravens Patriots Buccaneers Patriots Patriots Steelers Colts Giants Steelers WINNER -------------------- Saints Packers Giants 47 rows selected. SQL> select distinct from superbowls; select distinct from superbowls * ERROR at line 1: ORA-00936: missing expression SQL> select distinct winner from superbowls; WINNER -------------------- Dolphins Saints Bears Buccaneers Ravens Chiefs 49ers Packers Steelers Raiders Patriots WINNER -------------------- Colts Jets Cowboys Rams Broncos Redskins Giants 18 rows selected. SQL> select winner, loser from superbowls; WINNER LOSER -------------------- -------------------- Ravens 49ers Packers Chiefs Packers Raiders Jets Colts Chiefs Vikings Colts Cowboys Cowboys Dolphins Dolphins Redskins Dolphins Vikings Steelers Vikings Steelers Cowboys WINNER LOSER -------------------- -------------------- Raiders Vikings Cowboys Broncos Steelers Cowboys Steelers Rams Raiders Eagles 49ers Bengals Redskins Dolphins Raiders Redskins 49ers Dolphins Bears Patriots Giants Broncos WINNER LOSER -------------------- -------------------- Redskins Broncos 49ers Bengals 49ers Broncos Giants Bills Redskins Bills Cowboys Bills Cowboys Bills 49ers Chargers Cowboys Steelers Packers Patriots Broncos Packers WINNER LOSER -------------------- -------------------- Broncos Falcons Rams Titans Ravens Giants Patriots Rams Buccaneers Raiders Patriots Panthers Patriots Eagles Steelers Seahawks Colts Bears Giants Patriots Steelers Cardinals WINNER LOSER -------------------- -------------------- Saints Colts Packers Steelers Giants Patriots 47 rows selected. SQL> select distinct winner,loser from superbowls; WINNER LOSER -------------------- -------------------- Steelers Vikings Raiders Vikings Cowboys Broncos Raiders Redskins Packers Patriots Broncos Falcons Giants Patriots Cowboys Dolphins Giants Broncos 49ers Broncos Cowboys Bills WINNER LOSER -------------------- -------------------- Cowboys Steelers Patriots Eagles Steelers Seahawks Colts Cowboys Colts Bears Steelers Cardinals Dolphins Vikings Steelers Cowboys 49ers Bengals Redskins Dolphins Redskins Broncos WINNER LOSER -------------------- -------------------- Redskins Bills Patriots Panthers Saints Colts Packers Steelers Ravens 49ers Packers Chiefs Raiders Eagles Patriots Rams Buccaneers Raiders Packers Raiders Chiefs Vikings WINNER LOSER -------------------- -------------------- Dolphins Redskins Giants Bills 49ers Chargers Broncos Packers Rams Titans Jets Colts Steelers Rams Bears Patriots 49ers Dolphins Ravens Giants 43 rows selected. SQL> select winner, loser from superbowls order by winner, loser; WINNER LOSER -------------------- -------------------- 49ers Bengals 49ers Bengals 49ers Broncos 49ers Chargers 49ers Dolphins Bears Patriots Broncos Falcons Broncos Packers Buccaneers Raiders Chiefs Vikings Colts Bears WINNER LOSER -------------------- -------------------- Colts Cowboys Cowboys Bills Cowboys Bills Cowboys Broncos Cowboys Dolphins Cowboys Steelers Dolphins Redskins Dolphins Vikings Giants Bills Giants Broncos Giants Patriots WINNER LOSER -------------------- -------------------- Giants Patriots Jets Colts Packers Chiefs Packers Patriots Packers Raiders Packers Steelers Patriots Eagles Patriots Panthers Patriots Rams Raiders Eagles Raiders Redskins WINNER LOSER -------------------- -------------------- Raiders Vikings Rams Titans Ravens 49ers Ravens Giants Redskins Bills Redskins Broncos Redskins Dolphins Saints Colts Steelers Cardinals Steelers Cowboys Steelers Cowboys WINNER LOSER -------------------- -------------------- Steelers Rams Steelers Seahawks Steelers Vikings 47 rows selected. SQL> select distinct winner, loser from superbowls 2 order by winner,loser; WINNER LOSER -------------------- -------------------- 49ers Bengals 49ers Broncos 49ers Chargers 49ers Dolphins Bears Patriots Broncos Falcons Broncos Packers Buccaneers Raiders Chiefs Vikings Colts Bears Colts Cowboys WINNER LOSER -------------------- -------------------- Cowboys Bills Cowboys Broncos Cowboys Dolphins Cowboys Steelers Dolphins Redskins Dolphins Vikings Giants Bills Giants Broncos Giants Patriots Jets Colts Packers Chiefs WINNER LOSER -------------------- -------------------- Packers Patriots Packers Raiders Packers Steelers Patriots Eagles Patriots Panthers Patriots Rams Raiders Eagles Raiders Redskins Raiders Vikings Rams Titans Ravens 49ers WINNER LOSER -------------------- -------------------- Ravens Giants Redskins Bills Redskins Broncos Redskins Dolphins Saints Colts Steelers Cardinals Steelers Cowboys Steelers Rams Steelers Seahawks Steelers Vikings 43 rows selected. SQL> select distinct winner, loser from superbowls order by winner; WINNER LOSER -------------------- -------------------- 49ers Bengals 49ers Broncos 49ers Chargers 49ers Dolphins Bears Patriots Broncos Falcons Broncos Packers Buccaneers Raiders Chiefs Vikings Colts Bears Colts Cowboys WINNER LOSER -------------------- -------------------- Cowboys Bills Cowboys Broncos Cowboys Dolphins Cowboys Steelers Dolphins Redskins Dolphins Vikings Giants Bills Giants Broncos Giants Patriots Jets Colts Packers Chiefs WINNER LOSER -------------------- -------------------- Packers Patriots Packers Raiders Packers Steelers Patriots Eagles Patriots Panthers Patriots Rams Raiders Eagles Raiders Redskins Raiders Vikings Rams Titans Ravens 49ers WINNER LOSER -------------------- -------------------- Ravens Giants Redskins Bills Redskins Broncos Redskins Dolphins Saints Colts Steelers Cardinals Steelers Cowboys Steelers Rams Steelers Seahawks Steelers Vikings 43 rows selected. SQL> select * from superbowls order by winner, year; SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- 16 1982 49ers Bengals 19 1985 49ers Dolphins 23 1989 49ers Bengals 24 1990 49ers Broncos 29 1995 49ers Chargers 20 1986 Bears Patriots 32 1998 Broncos Packers 33 1999 Broncos Falcons 37 2003 Buccaneers Raiders 4 1970 Chiefs Vikings 5 1971 Colts Cowboys SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- 41 2007 Colts Bears 6 1972 Cowboys Dolphins 12 1978 Cowboys Broncos 27 1993 Cowboys Bills 28 1994 Cowboys Bills 30 1996 Cowboys Steelers 7 1973 Dolphins Redskins 8 1974 Dolphins Vikings 21 1987 Giants Broncos 25 1991 Giants Bills 42 2008 Giants Patriots SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- 46 2012 Giants Patriots 3 1969 Jets Colts 1 1967 Packers Chiefs 2 1968 Packers Raiders 31 1997 Packers Patriots 45 2011 Packers Steelers 36 2002 Patriots Rams 38 2004 Patriots Panthers 39 2005 Patriots Eagles 11 1977 Raiders Vikings 15 1981 Raiders Eagles SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- 18 1984 Raiders Redskins 34 2000 Rams Titans 35 2001 Ravens Giants 47 2013 Ravens 49ers 17 1983 Redskins Dolphins 22 1988 Redskins Broncos 26 1992 Redskins Bills 44 2010 Saints Colts 9 1975 Steelers Vikings 10 1976 Steelers Cowboys 13 1979 Steelers Cowboys SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- 14 1980 Steelers Rams 40 2006 Steelers Seahawks 43 2009 Steelers Cardinals 47 rows selected. SQL> select * from superbowls order by winner; SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- 16 1982 49ers Bengals 23 1989 49ers Bengals 24 1990 49ers Broncos 29 1995 49ers Chargers 19 1985 49ers Dolphins 20 1986 Bears Patriots 32 1998 Broncos Packers 33 1999 Broncos Falcons 37 2003 Buccaneers Raiders 4 1970 Chiefs Vikings 5 1971 Colts Cowboys SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- 41 2007 Colts Bears 12 1978 Cowboys Broncos 30 1996 Cowboys Steelers 6 1972 Cowboys Dolphins 28 1994 Cowboys Bills 27 1993 Cowboys Bills 8 1974 Dolphins Vikings 7 1973 Dolphins Redskins 42 2008 Giants Patriots 46 2012 Giants Patriots 21 1987 Giants Broncos SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- 25 1991 Giants Bills 3 1969 Jets Colts 2 1968 Packers Raiders 1 1967 Packers Chiefs 45 2011 Packers Steelers 31 1997 Packers Patriots 38 2004 Patriots Panthers 39 2005 Patriots Eagles 36 2002 Patriots Rams 11 1977 Raiders Vikings 18 1984 Raiders Redskins SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- 15 1981 Raiders Eagles 34 2000 Rams Titans 47 2013 Ravens 49ers 35 2001 Ravens Giants 17 1983 Redskins Dolphins 26 1992 Redskins Bills 22 1988 Redskins Broncos 44 2010 Saints Colts 40 2006 Steelers Seahawks 9 1975 Steelers Vikings 43 2009 Steelers Cardinals SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- 14 1980 Steelers Rams 13 1979 Steelers Cowboys 10 1976 Steelers Cowboys 47 rows selected. SQL> select * from superbowls; SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- 47 2013 Ravens 49ers 1 1967 Packers Chiefs 2 1968 Packers Raiders 3 1969 Jets Colts 4 1970 Chiefs Vikings 5 1971 Colts Cowboys 6 1972 Cowboys Dolphins 7 1973 Dolphins Redskins 8 1974 Dolphins Vikings 9 1975 Steelers Vikings 10 1976 Steelers Cowboys SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- 11 1977 Raiders Vikings 12 1978 Cowboys Broncos 13 1979 Steelers Cowboys 14 1980 Steelers Rams 15 1981 Raiders Eagles 16 1982 49ers Bengals 17 1983 Redskins Dolphins 18 1984 Raiders Redskins 19 1985 49ers Dolphins 20 1986 Bears Patriots 21 1987 Giants Broncos SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- 22 1988 Redskins Broncos 23 1989 49ers Bengals 24 1990 49ers Broncos 25 1991 Giants Bills 26 1992 Redskins Bills 27 1993 Cowboys Bills 28 1994 Cowboys Bills 29 1995 49ers Chargers 30 1996 Cowboys Steelers 31 1997 Packers Patriots 32 1998 Broncos Packers SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- 33 1999 Broncos Falcons 34 2000 Rams Titans 35 2001 Ravens Giants 36 2002 Patriots Rams 37 2003 Buccaneers Raiders 38 2004 Patriots Panthers 39 2005 Patriots Eagles 40 2006 Steelers Seahawks 41 2007 Colts Bears 42 2008 Giants Patriots 43 2009 Steelers Cardinals SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- 44 2010 Saints Colts 45 2011 Packers Steelers 46 2012 Giants Patriots 47 rows selected. SQL> SQL> select * 2 from teams t, superbowls s 3 where t.teamname = s.loser; TEAMNAME LOCATION SUPERBOWLWINS SBNO YEAR -------------------- -------------------- ------------- ---------- ---------- WINNER LOSER -------------------- -------------------- 49ers San Francsico 5 47 2013 Ravens 49ers Bears Chicago 1 41 2007 Colts Bears Bengals Cincinnati 0 23 1989 49ers Bengals TEAMNAME LOCATION SUPERBOWLWINS SBNO YEAR -------------------- -------------------- ------------- ---------- ---------- WINNER LOSER -------------------- -------------------- Bengals Cincinnati 0 16 1982 49ers Bengals Bills Buffalo 0 27 1993 Cowboys Bills Bills Buffalo 0 28 1994 Cowboys Bills TEAMNAME LOCATION SUPERBOWLWINS SBNO YEAR -------------------- -------------------- ------------- ---------- ---------- WINNER LOSER -------------------- -------------------- Bills Buffalo 0 26 1992 Redskins Bills Bills Buffalo 0 25 1991 Giants Bills Broncos Denver 2 24 1990 49ers Broncos TEAMNAME LOCATION SUPERBOWLWINS SBNO YEAR -------------------- -------------------- ------------- ---------- ---------- WINNER LOSER -------------------- -------------------- Broncos Denver 2 22 1988 Redskins Broncos Broncos Denver 2 21 1987 Giants Broncos Broncos Denver 2 12 1978 Cowboys Broncos TEAMNAME LOCATION SUPERBOWLWINS SBNO YEAR -------------------- -------------------- ------------- ---------- ---------- WINNER LOSER -------------------- -------------------- Cardinals Arizona 0 43 2009 Steelers Cardinals Chargers San Diego 0 29 1995 49ers Chargers Chiefs Kansas City 1 1 1967 Packers Chiefs TEAMNAME LOCATION SUPERBOWLWINS SBNO YEAR -------------------- -------------------- ------------- ---------- ---------- WINNER LOSER -------------------- -------------------- Colts Indianapolis 2 3 1969 Jets Colts Colts Indianapolis 2 44 2010 Saints Colts Cowboys Dallas 5 13 1979 Steelers Cowboys TEAMNAME LOCATION SUPERBOWLWINS SBNO YEAR -------------------- -------------------- ------------- ---------- ---------- WINNER LOSER -------------------- -------------------- Cowboys Dallas 5 5 1971 Colts Cowboys Cowboys Dallas 5 10 1976 Steelers Cowboys Dolphins Miami 2 19 1985 49ers Dolphins TEAMNAME LOCATION SUPERBOWLWINS SBNO YEAR -------------------- -------------------- ------------- ---------- ---------- WINNER LOSER -------------------- -------------------- Dolphins Miami 2 17 1983 Redskins Dolphins Dolphins Miami 2 6 1972 Cowboys Dolphins Eagles Philadelphia 0 39 2005 Patriots Eagles TEAMNAME LOCATION SUPERBOWLWINS SBNO YEAR -------------------- -------------------- ------------- ---------- ---------- WINNER LOSER -------------------- -------------------- Eagles Philadelphia 0 15 1981 Raiders Eagles Falcons Atlanta 0 33 1999 Broncos Falcons Giants New York 4 35 2001 Ravens Giants TEAMNAME LOCATION SUPERBOWLWINS SBNO YEAR -------------------- -------------------- ------------- ---------- ---------- WINNER LOSER -------------------- -------------------- Packers Green Bay 4 32 1998 Broncos Packers Panthers Carolina 0 38 2004 Patriots Panthers Patriots New England 3 42 2008 Giants Patriots TEAMNAME LOCATION SUPERBOWLWINS SBNO YEAR -------------------- -------------------- ------------- ---------- ---------- WINNER LOSER -------------------- -------------------- Patriots New England 3 46 2012 Giants Patriots Patriots New England 3 20 1986 Bears Patriots Patriots New England 3 31 1997 Packers Patriots TEAMNAME LOCATION SUPERBOWLWINS SBNO YEAR -------------------- -------------------- ------------- ---------- ---------- WINNER LOSER -------------------- -------------------- Raiders Oakland 3 37 2003 Buccaneers Raiders Raiders Oakland 3 2 1968 Packers Raiders Rams St. Louis 1 36 2002 Patriots Rams TEAMNAME LOCATION SUPERBOWLWINS SBNO YEAR -------------------- -------------------- ------------- ---------- ---------- WINNER LOSER -------------------- -------------------- Rams St. Louis 1 14 1980 Steelers Rams Redskins Washington 3 7 1973 Dolphins Redskins Redskins Washington 3 18 1984 Raiders Redskins TEAMNAME LOCATION SUPERBOWLWINS SBNO YEAR -------------------- -------------------- ------------- ---------- ---------- WINNER LOSER -------------------- -------------------- Seahawks Seattle 0 40 2006 Steelers Seahawks Steelers Pittsburgh 6 30 1996 Cowboys Steelers Steelers Pittsburgh 6 45 2011 Packers Steelers TEAMNAME LOCATION SUPERBOWLWINS SBNO YEAR -------------------- -------------------- ------------- ---------- ---------- WINNER LOSER -------------------- -------------------- Titans Tennessee 0 34 2000 Rams Titans Vikings Minnesota 0 8 1974 Dolphins Vikings Vikings Minnesota 0 9 1975 Steelers Vikings TEAMNAME LOCATION SUPERBOWLWINS SBNO YEAR -------------------- -------------------- ------------- ---------- ---------- WINNER LOSER -------------------- -------------------- Vikings Minnesota 0 11 1977 Raiders Vikings Vikings Minnesota 0 4 1970 Chiefs Vikings 47 rows selected. SQL> select * from late; SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- 35 2001 Ravens Giants 36 2002 Patriots Rams 37 2003 Buccaneers Raiders 38 2004 Patriots Panthers 39 2005 Patriots Eagles 40 2006 Steelers Seahawks 41 2007 Colts Bears 42 2008 Giants Patriots 43 2009 Steelers Cardinals 44 2010 Saints Colts 45 2011 Packers Steelers SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- 46 2012 Giants Patriots 47 2013 Ravens 49ers 13 rows selected. SQL> select * from early; SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- 1 1967 Packers Chiefs 2 1968 Packers Raiders 3 1969 Jets Colts SQL> select distinct winner 2 from early, late 3 where winner=winner; where winner=winner * ERROR at line 3: ORA-00918: column ambiguously defined SQL> select distinct winner from early, late 2 where early.winner = late.winner; select distinct winner from early, late * ERROR at line 1: ORA-00918: column ambiguously defined SQL> select distinct early.winner 2 from early, late 3 where late.winner = early.winner 4 ; WINNER -------------------- Packers SQL> select * from early, late; SBNO YEAR WINNER LOSER SBNO ---------- ---------- -------------------- -------------------- ---------- YEAR WINNER LOSER ---------- -------------------- -------------------- 1 1967 Packers Chiefs 35 2001 Ravens Giants 1 1967 Packers Chiefs 36 2002 Patriots Rams 1 1967 Packers Chiefs 37 2003 Buccaneers Raiders SBNO YEAR WINNER LOSER SBNO ---------- ---------- -------------------- -------------------- ---------- YEAR WINNER LOSER ---------- -------------------- -------------------- 1 1967 Packers Chiefs 38 2004 Patriots Panthers 1 1967 Packers Chiefs 39 2005 Patriots Eagles 1 1967 Packers Chiefs 40 2006 Steelers Seahawks SBNO YEAR WINNER LOSER SBNO ---------- ---------- -------------------- -------------------- ---------- YEAR WINNER LOSER ---------- -------------------- -------------------- 1 1967 Packers Chiefs 41 2007 Colts Bears 1 1967 Packers Chiefs 42 2008 Giants Patriots 1 1967 Packers Chiefs 43 2009 Steelers Cardinals SBNO YEAR WINNER LOSER SBNO ---------- ---------- -------------------- -------------------- ---------- YEAR WINNER LOSER ---------- -------------------- -------------------- 1 1967 Packers Chiefs 44 2010 Saints Colts 1 1967 Packers Chiefs 45 2011 Packers Steelers 1 1967 Packers Chiefs 46 2012 Giants Patriots SBNO YEAR WINNER LOSER SBNO ---------- ---------- -------------------- -------------------- ---------- YEAR WINNER LOSER ---------- -------------------- -------------------- 1 1967 Packers Chiefs 47 2013 Ravens 49ers 2 1968 Packers Raiders 35 2001 Ravens Giants 2 1968 Packers Raiders 36 2002 Patriots Rams SBNO YEAR WINNER LOSER SBNO ---------- ---------- -------------------- -------------------- ---------- YEAR WINNER LOSER ---------- -------------------- -------------------- 2 1968 Packers Raiders 37 2003 Buccaneers Raiders 2 1968 Packers Raiders 38 2004 Patriots Panthers 2 1968 Packers Raiders 39 2005 Patriots Eagles SBNO YEAR WINNER LOSER SBNO ---------- ---------- -------------------- -------------------- ---------- YEAR WINNER LOSER ---------- -------------------- -------------------- 2 1968 Packers Raiders 40 2006 Steelers Seahawks 2 1968 Packers Raiders 41 2007 Colts Bears 2 1968 Packers Raiders 42 2008 Giants Patriots SBNO YEAR WINNER LOSER SBNO ---------- ---------- -------------------- -------------------- ---------- YEAR WINNER LOSER ---------- -------------------- -------------------- 2 1968 Packers Raiders 43 2009 Steelers Cardinals 2 1968 Packers Raiders 44 2010 Saints Colts 2 1968 Packers Raiders 45 2011 Packers Steelers SBNO YEAR WINNER LOSER SBNO ---------- ---------- -------------------- -------------------- ---------- YEAR WINNER LOSER ---------- -------------------- -------------------- 2 1968 Packers Raiders 46 2012 Giants Patriots 2 1968 Packers Raiders 47 2013 Ravens 49ers 3 1969 Jets Colts 35 2001 Ravens Giants SBNO YEAR WINNER LOSER SBNO ---------- ---------- -------------------- -------------------- ---------- YEAR WINNER LOSER ---------- -------------------- -------------------- 3 1969 Jets Colts 36 2002 Patriots Rams 3 1969 Jets Colts 37 2003 Buccaneers Raiders 3 1969 Jets Colts 38 2004 Patriots Panthers SBNO YEAR WINNER LOSER SBNO ---------- ---------- -------------------- -------------------- ---------- YEAR WINNER LOSER ---------- -------------------- -------------------- 3 1969 Jets Colts 39 2005 Patriots Eagles 3 1969 Jets Colts 40 2006 Steelers Seahawks 3 1969 Jets Colts 41 2007 Colts Bears SBNO YEAR WINNER LOSER SBNO ---------- ---------- -------------------- -------------------- ---------- YEAR WINNER LOSER ---------- -------------------- -------------------- 3 1969 Jets Colts 42 2008 Giants Patriots 3 1969 Jets Colts 43 2009 Steelers Cardinals 3 1969 Jets Colts 44 2010 Saints Colts SBNO YEAR WINNER LOSER SBNO ---------- ---------- -------------------- -------------------- ---------- YEAR WINNER LOSER ---------- -------------------- -------------------- 3 1969 Jets Colts 45 2011 Packers Steelers 3 1969 Jets Colts 46 2012 Giants Patriots 3 1969 Jets Colts 47 2013 Ravens 49ers 39 rows selected. SQL> set linesize 200 SQL> run 1* select * from early, late SBNO YEAR WINNER LOSER SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- ---------- ---------- -------------------- -------------------- 1 1967 Packers Chiefs 35 2001 Ravens Giants 1 1967 Packers Chiefs 36 2002 Patriots Rams 1 1967 Packers Chiefs 37 2003 Buccaneers Raiders 1 1967 Packers Chiefs 38 2004 Patriots Panthers 1 1967 Packers Chiefs 39 2005 Patriots Eagles 1 1967 Packers Chiefs 40 2006 Steelers Seahawks 1 1967 Packers Chiefs 41 2007 Colts Bears 1 1967 Packers Chiefs 42 2008 Giants Patriots 1 1967 Packers Chiefs 43 2009 Steelers Cardinals 1 1967 Packers Chiefs 44 2010 Saints Colts 1 1967 Packers Chiefs 45 2011 Packers Steelers SBNO YEAR WINNER LOSER SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- ---------- ---------- -------------------- -------------------- 1 1967 Packers Chiefs 46 2012 Giants Patriots 1 1967 Packers Chiefs 47 2013 Ravens 49ers 2 1968 Packers Raiders 35 2001 Ravens Giants 2 1968 Packers Raiders 36 2002 Patriots Rams 2 1968 Packers Raiders 37 2003 Buccaneers Raiders 2 1968 Packers Raiders 38 2004 Patriots Panthers 2 1968 Packers Raiders 39 2005 Patriots Eagles 2 1968 Packers Raiders 40 2006 Steelers Seahawks 2 1968 Packers Raiders 41 2007 Colts Bears 2 1968 Packers Raiders 42 2008 Giants Patriots 2 1968 Packers Raiders 43 2009 Steelers Cardinals SBNO YEAR WINNER LOSER SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- ---------- ---------- -------------------- -------------------- 2 1968 Packers Raiders 44 2010 Saints Colts 2 1968 Packers Raiders 45 2011 Packers Steelers 2 1968 Packers Raiders 46 2012 Giants Patriots 2 1968 Packers Raiders 47 2013 Ravens 49ers 3 1969 Jets Colts 35 2001 Ravens Giants 3 1969 Jets Colts 36 2002 Patriots Rams 3 1969 Jets Colts 37 2003 Buccaneers Raiders 3 1969 Jets Colts 38 2004 Patriots Panthers 3 1969 Jets Colts 39 2005 Patriots Eagles 3 1969 Jets Colts 40 2006 Steelers Seahawks 3 1969 Jets Colts 41 2007 Colts Bears SBNO YEAR WINNER LOSER SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- ---------- ---------- -------------------- -------------------- 3 1969 Jets Colts 42 2008 Giants Patriots 3 1969 Jets Colts 43 2009 Steelers Cardinals 3 1969 Jets Colts 44 2010 Saints Colts 3 1969 Jets Colts 45 2011 Packers Steelers 3 1969 Jets Colts 46 2012 Giants Patriots 3 1969 Jets Colts 47 2013 Ravens 49ers 39 rows selected. SQL> create table combo AS (select * from early, late); create table combo AS (select * from early, late) * ERROR at line 1: ORA-00957: duplicate column name SQL> select early.winner from early, late where early.winner = late.winner; WINNER -------------------- Packers Packers SQL> select * from teams order by superbowlwins; TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- Browns Cleveland 0 Texans Houston 0 Lions Detroit 0 Cardinals Arizona 0 Seahawks Seattle 0 Panthers Carolina 0 Jaguars Jacksonville 0 Falcons Atlanta 0 Chargers San Diego 0 Eagles Philadelphia 0 Bengals Cincinnati 0 TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- Vikings Minnesota 0 Bills Buffalo 0 Titans Tennessee 0 Ravens Baltimore 1 Chiefs Kansas City 1 Rams St. Louis 1 Bears Chicago 1 Saints New Orleans 1 Buccaneers Tampa Bay 1 Jets New York 1 Broncos Denver 2 TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- Dolphins Miami 2 Colts Indianapolis 2 Patriots New England 3 Redskins Washington 3 Raiders Oakland 3 Giants New York 4 Packers Green Bay 4 49ers San Francsico 5 Cowboys Dallas 5 Steelers Pittsburgh 6 32 rows selected. SQL> SELECT t1.teamname 2 FROM teams t1, teams t2 3 WHERE t1.superbowlwins > t2.superbowlwins 4 and t2.teamname = '49ers' 5 ; TEAMNAME -------------------- Steelers SQL> select * from teams, teams; select * from teams, teams * ERROR at line 1: ORA-00918: column ambiguously defined SQL> select * from teams t1, teams t2; TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Steelers Pittsburgh 6 Steelers Pittsburgh 6 Steelers Pittsburgh 6 Cowboys Dallas 5 Steelers Pittsburgh 6 Patriots New England 3 Steelers Pittsburgh 6 49ers San Francsico 5 Steelers Pittsburgh 6 Broncos Denver 2 Steelers Pittsburgh 6 Packers Green Bay 4 Steelers Pittsburgh 6 Giants New York 4 Steelers Pittsburgh 6 Redskins Washington 3 Steelers Pittsburgh 6 Raiders Oakland 3 Steelers Pittsburgh 6 Dolphins Miami 2 Steelers Pittsburgh 6 Colts Indianapolis 2 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Steelers Pittsburgh 6 Vikings Minnesota 0 Steelers Pittsburgh 6 Bills Buffalo 0 Steelers Pittsburgh 6 Rams St. Louis 1 Steelers Pittsburgh 6 Chiefs Kansas City 1 Steelers Pittsburgh 6 Bears Chicago 1 Steelers Pittsburgh 6 Ravens Baltimore 1 Steelers Pittsburgh 6 Bengals Cincinnati 0 Steelers Pittsburgh 6 Eagles Philadelphia 0 Steelers Pittsburgh 6 Jets New York 1 Steelers Pittsburgh 6 Buccaneers Tampa Bay 1 Steelers Pittsburgh 6 Saints New Orleans 1 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Steelers Pittsburgh 6 Chargers San Diego 0 Steelers Pittsburgh 6 Falcons Atlanta 0 Steelers Pittsburgh 6 Titans Tennessee 0 Steelers Pittsburgh 6 Panthers Carolina 0 Steelers Pittsburgh 6 Seahawks Seattle 0 Steelers Pittsburgh 6 Cardinals Arizona 0 Steelers Pittsburgh 6 Browns Cleveland 0 Steelers Pittsburgh 6 Lions Detroit 0 Steelers Pittsburgh 6 Jaguars Jacksonville 0 Steelers Pittsburgh 6 Texans Houston 0 Cowboys Dallas 5 Steelers Pittsburgh 6 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Cowboys Dallas 5 Cowboys Dallas 5 Cowboys Dallas 5 Patriots New England 3 Cowboys Dallas 5 49ers San Francsico 5 Cowboys Dallas 5 Broncos Denver 2 Cowboys Dallas 5 Packers Green Bay 4 Cowboys Dallas 5 Giants New York 4 Cowboys Dallas 5 Redskins Washington 3 Cowboys Dallas 5 Raiders Oakland 3 Cowboys Dallas 5 Dolphins Miami 2 Cowboys Dallas 5 Colts Indianapolis 2 Cowboys Dallas 5 Vikings Minnesota 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Cowboys Dallas 5 Bills Buffalo 0 Cowboys Dallas 5 Rams St. Louis 1 Cowboys Dallas 5 Chiefs Kansas City 1 Cowboys Dallas 5 Bears Chicago 1 Cowboys Dallas 5 Ravens Baltimore 1 Cowboys Dallas 5 Bengals Cincinnati 0 Cowboys Dallas 5 Eagles Philadelphia 0 Cowboys Dallas 5 Jets New York 1 Cowboys Dallas 5 Buccaneers Tampa Bay 1 Cowboys Dallas 5 Saints New Orleans 1 Cowboys Dallas 5 Chargers San Diego 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Cowboys Dallas 5 Falcons Atlanta 0 Cowboys Dallas 5 Titans Tennessee 0 Cowboys Dallas 5 Panthers Carolina 0 Cowboys Dallas 5 Seahawks Seattle 0 Cowboys Dallas 5 Cardinals Arizona 0 Cowboys Dallas 5 Browns Cleveland 0 Cowboys Dallas 5 Lions Detroit 0 Cowboys Dallas 5 Jaguars Jacksonville 0 Cowboys Dallas 5 Texans Houston 0 Patriots New England 3 Steelers Pittsburgh 6 Patriots New England 3 Cowboys Dallas 5 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Patriots New England 3 Patriots New England 3 Patriots New England 3 49ers San Francsico 5 Patriots New England 3 Broncos Denver 2 Patriots New England 3 Packers Green Bay 4 Patriots New England 3 Giants New York 4 Patriots New England 3 Redskins Washington 3 Patriots New England 3 Raiders Oakland 3 Patriots New England 3 Dolphins Miami 2 Patriots New England 3 Colts Indianapolis 2 Patriots New England 3 Vikings Minnesota 0 Patriots New England 3 Bills Buffalo 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Patriots New England 3 Rams St. Louis 1 Patriots New England 3 Chiefs Kansas City 1 Patriots New England 3 Bears Chicago 1 Patriots New England 3 Ravens Baltimore 1 Patriots New England 3 Bengals Cincinnati 0 Patriots New England 3 Eagles Philadelphia 0 Patriots New England 3 Jets New York 1 Patriots New England 3 Buccaneers Tampa Bay 1 Patriots New England 3 Saints New Orleans 1 Patriots New England 3 Chargers San Diego 0 Patriots New England 3 Falcons Atlanta 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Patriots New England 3 Titans Tennessee 0 Patriots New England 3 Panthers Carolina 0 Patriots New England 3 Seahawks Seattle 0 Patriots New England 3 Cardinals Arizona 0 Patriots New England 3 Browns Cleveland 0 Patriots New England 3 Lions Detroit 0 Patriots New England 3 Jaguars Jacksonville 0 Patriots New England 3 Texans Houston 0 49ers San Francsico 5 Steelers Pittsburgh 6 49ers San Francsico 5 Cowboys Dallas 5 49ers San Francsico 5 Patriots New England 3 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- 49ers San Francsico 5 49ers San Francsico 5 49ers San Francsico 5 Broncos Denver 2 49ers San Francsico 5 Packers Green Bay 4 49ers San Francsico 5 Giants New York 4 49ers San Francsico 5 Redskins Washington 3 49ers San Francsico 5 Raiders Oakland 3 49ers San Francsico 5 Dolphins Miami 2 49ers San Francsico 5 Colts Indianapolis 2 49ers San Francsico 5 Vikings Minnesota 0 49ers San Francsico 5 Bills Buffalo 0 49ers San Francsico 5 Rams St. Louis 1 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- 49ers San Francsico 5 Chiefs Kansas City 1 49ers San Francsico 5 Bears Chicago 1 49ers San Francsico 5 Ravens Baltimore 1 49ers San Francsico 5 Bengals Cincinnati 0 49ers San Francsico 5 Eagles Philadelphia 0 49ers San Francsico 5 Jets New York 1 49ers San Francsico 5 Buccaneers Tampa Bay 1 49ers San Francsico 5 Saints New Orleans 1 49ers San Francsico 5 Chargers San Diego 0 49ers San Francsico 5 Falcons Atlanta 0 49ers San Francsico 5 Titans Tennessee 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- 49ers San Francsico 5 Panthers Carolina 0 49ers San Francsico 5 Seahawks Seattle 0 49ers San Francsico 5 Cardinals Arizona 0 49ers San Francsico 5 Browns Cleveland 0 49ers San Francsico 5 Lions Detroit 0 49ers San Francsico 5 Jaguars Jacksonville 0 49ers San Francsico 5 Texans Houston 0 Broncos Denver 2 Steelers Pittsburgh 6 Broncos Denver 2 Cowboys Dallas 5 Broncos Denver 2 Patriots New England 3 Broncos Denver 2 49ers San Francsico 5 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Broncos Denver 2 Broncos Denver 2 Broncos Denver 2 Packers Green Bay 4 Broncos Denver 2 Giants New York 4 Broncos Denver 2 Redskins Washington 3 Broncos Denver 2 Raiders Oakland 3 Broncos Denver 2 Dolphins Miami 2 Broncos Denver 2 Colts Indianapolis 2 Broncos Denver 2 Vikings Minnesota 0 Broncos Denver 2 Bills Buffalo 0 Broncos Denver 2 Rams St. Louis 1 Broncos Denver 2 Chiefs Kansas City 1 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Broncos Denver 2 Bears Chicago 1 Broncos Denver 2 Ravens Baltimore 1 Broncos Denver 2 Bengals Cincinnati 0 Broncos Denver 2 Eagles Philadelphia 0 Broncos Denver 2 Jets New York 1 Broncos Denver 2 Buccaneers Tampa Bay 1 Broncos Denver 2 Saints New Orleans 1 Broncos Denver 2 Chargers San Diego 0 Broncos Denver 2 Falcons Atlanta 0 Broncos Denver 2 Titans Tennessee 0 Broncos Denver 2 Panthers Carolina 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Broncos Denver 2 Seahawks Seattle 0 Broncos Denver 2 Cardinals Arizona 0 Broncos Denver 2 Browns Cleveland 0 Broncos Denver 2 Lions Detroit 0 Broncos Denver 2 Jaguars Jacksonville 0 Broncos Denver 2 Texans Houston 0 Packers Green Bay 4 Steelers Pittsburgh 6 Packers Green Bay 4 Cowboys Dallas 5 Packers Green Bay 4 Patriots New England 3 Packers Green Bay 4 49ers San Francsico 5 Packers Green Bay 4 Broncos Denver 2 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Packers Green Bay 4 Packers Green Bay 4 Packers Green Bay 4 Giants New York 4 Packers Green Bay 4 Redskins Washington 3 Packers Green Bay 4 Raiders Oakland 3 Packers Green Bay 4 Dolphins Miami 2 Packers Green Bay 4 Colts Indianapolis 2 Packers Green Bay 4 Vikings Minnesota 0 Packers Green Bay 4 Bills Buffalo 0 Packers Green Bay 4 Rams St. Louis 1 Packers Green Bay 4 Chiefs Kansas City 1 Packers Green Bay 4 Bears Chicago 1 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Packers Green Bay 4 Ravens Baltimore 1 Packers Green Bay 4 Bengals Cincinnati 0 Packers Green Bay 4 Eagles Philadelphia 0 Packers Green Bay 4 Jets New York 1 Packers Green Bay 4 Buccaneers Tampa Bay 1 Packers Green Bay 4 Saints New Orleans 1 Packers Green Bay 4 Chargers San Diego 0 Packers Green Bay 4 Falcons Atlanta 0 Packers Green Bay 4 Titans Tennessee 0 Packers Green Bay 4 Panthers Carolina 0 Packers Green Bay 4 Seahawks Seattle 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Packers Green Bay 4 Cardinals Arizona 0 Packers Green Bay 4 Browns Cleveland 0 Packers Green Bay 4 Lions Detroit 0 Packers Green Bay 4 Jaguars Jacksonville 0 Packers Green Bay 4 Texans Houston 0 Giants New York 4 Steelers Pittsburgh 6 Giants New York 4 Cowboys Dallas 5 Giants New York 4 Patriots New England 3 Giants New York 4 49ers San Francsico 5 Giants New York 4 Broncos Denver 2 Giants New York 4 Packers Green Bay 4 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Giants New York 4 Giants New York 4 Giants New York 4 Redskins Washington 3 Giants New York 4 Raiders Oakland 3 Giants New York 4 Dolphins Miami 2 Giants New York 4 Colts Indianapolis 2 Giants New York 4 Vikings Minnesota 0 Giants New York 4 Bills Buffalo 0 Giants New York 4 Rams St. Louis 1 Giants New York 4 Chiefs Kansas City 1 Giants New York 4 Bears Chicago 1 Giants New York 4 Ravens Baltimore 1 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Giants New York 4 Bengals Cincinnati 0 Giants New York 4 Eagles Philadelphia 0 Giants New York 4 Jets New York 1 Giants New York 4 Buccaneers Tampa Bay 1 Giants New York 4 Saints New Orleans 1 Giants New York 4 Chargers San Diego 0 Giants New York 4 Falcons Atlanta 0 Giants New York 4 Titans Tennessee 0 Giants New York 4 Panthers Carolina 0 Giants New York 4 Seahawks Seattle 0 Giants New York 4 Cardinals Arizona 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Giants New York 4 Browns Cleveland 0 Giants New York 4 Lions Detroit 0 Giants New York 4 Jaguars Jacksonville 0 Giants New York 4 Texans Houston 0 Redskins Washington 3 Steelers Pittsburgh 6 Redskins Washington 3 Cowboys Dallas 5 Redskins Washington 3 Patriots New England 3 Redskins Washington 3 49ers San Francsico 5 Redskins Washington 3 Broncos Denver 2 Redskins Washington 3 Packers Green Bay 4 Redskins Washington 3 Giants New York 4 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Redskins Washington 3 Redskins Washington 3 Redskins Washington 3 Raiders Oakland 3 Redskins Washington 3 Dolphins Miami 2 Redskins Washington 3 Colts Indianapolis 2 Redskins Washington 3 Vikings Minnesota 0 Redskins Washington 3 Bills Buffalo 0 Redskins Washington 3 Rams St. Louis 1 Redskins Washington 3 Chiefs Kansas City 1 Redskins Washington 3 Bears Chicago 1 Redskins Washington 3 Ravens Baltimore 1 Redskins Washington 3 Bengals Cincinnati 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Redskins Washington 3 Eagles Philadelphia 0 Redskins Washington 3 Jets New York 1 Redskins Washington 3 Buccaneers Tampa Bay 1 Redskins Washington 3 Saints New Orleans 1 Redskins Washington 3 Chargers San Diego 0 Redskins Washington 3 Falcons Atlanta 0 Redskins Washington 3 Titans Tennessee 0 Redskins Washington 3 Panthers Carolina 0 Redskins Washington 3 Seahawks Seattle 0 Redskins Washington 3 Cardinals Arizona 0 Redskins Washington 3 Browns Cleveland 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Redskins Washington 3 Lions Detroit 0 Redskins Washington 3 Jaguars Jacksonville 0 Redskins Washington 3 Texans Houston 0 Raiders Oakland 3 Steelers Pittsburgh 6 Raiders Oakland 3 Cowboys Dallas 5 Raiders Oakland 3 Patriots New England 3 Raiders Oakland 3 49ers San Francsico 5 Raiders Oakland 3 Broncos Denver 2 Raiders Oakland 3 Packers Green Bay 4 Raiders Oakland 3 Giants New York 4 Raiders Oakland 3 Redskins Washington 3 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Raiders Oakland 3 Raiders Oakland 3 Raiders Oakland 3 Dolphins Miami 2 Raiders Oakland 3 Colts Indianapolis 2 Raiders Oakland 3 Vikings Minnesota 0 Raiders Oakland 3 Bills Buffalo 0 Raiders Oakland 3 Rams St. Louis 1 Raiders Oakland 3 Chiefs Kansas City 1 Raiders Oakland 3 Bears Chicago 1 Raiders Oakland 3 Ravens Baltimore 1 Raiders Oakland 3 Bengals Cincinnati 0 Raiders Oakland 3 Eagles Philadelphia 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Raiders Oakland 3 Jets New York 1 Raiders Oakland 3 Buccaneers Tampa Bay 1 Raiders Oakland 3 Saints New Orleans 1 Raiders Oakland 3 Chargers San Diego 0 Raiders Oakland 3 Falcons Atlanta 0 Raiders Oakland 3 Titans Tennessee 0 Raiders Oakland 3 Panthers Carolina 0 Raiders Oakland 3 Seahawks Seattle 0 Raiders Oakland 3 Cardinals Arizona 0 Raiders Oakland 3 Browns Cleveland 0 Raiders Oakland 3 Lions Detroit 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Raiders Oakland 3 Jaguars Jacksonville 0 Raiders Oakland 3 Texans Houston 0 Dolphins Miami 2 Steelers Pittsburgh 6 Dolphins Miami 2 Cowboys Dallas 5 Dolphins Miami 2 Patriots New England 3 Dolphins Miami 2 49ers San Francsico 5 Dolphins Miami 2 Broncos Denver 2 Dolphins Miami 2 Packers Green Bay 4 Dolphins Miami 2 Giants New York 4 Dolphins Miami 2 Redskins Washington 3 Dolphins Miami 2 Raiders Oakland 3 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Dolphins Miami 2 Dolphins Miami 2 Dolphins Miami 2 Colts Indianapolis 2 Dolphins Miami 2 Vikings Minnesota 0 Dolphins Miami 2 Bills Buffalo 0 Dolphins Miami 2 Rams St. Louis 1 Dolphins Miami 2 Chiefs Kansas City 1 Dolphins Miami 2 Bears Chicago 1 Dolphins Miami 2 Ravens Baltimore 1 Dolphins Miami 2 Bengals Cincinnati 0 Dolphins Miami 2 Eagles Philadelphia 0 Dolphins Miami 2 Jets New York 1 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Dolphins Miami 2 Buccaneers Tampa Bay 1 Dolphins Miami 2 Saints New Orleans 1 Dolphins Miami 2 Chargers San Diego 0 Dolphins Miami 2 Falcons Atlanta 0 Dolphins Miami 2 Titans Tennessee 0 Dolphins Miami 2 Panthers Carolina 0 Dolphins Miami 2 Seahawks Seattle 0 Dolphins Miami 2 Cardinals Arizona 0 Dolphins Miami 2 Browns Cleveland 0 Dolphins Miami 2 Lions Detroit 0 Dolphins Miami 2 Jaguars Jacksonville 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Dolphins Miami 2 Texans Houston 0 Colts Indianapolis 2 Steelers Pittsburgh 6 Colts Indianapolis 2 Cowboys Dallas 5 Colts Indianapolis 2 Patriots New England 3 Colts Indianapolis 2 49ers San Francsico 5 Colts Indianapolis 2 Broncos Denver 2 Colts Indianapolis 2 Packers Green Bay 4 Colts Indianapolis 2 Giants New York 4 Colts Indianapolis 2 Redskins Washington 3 Colts Indianapolis 2 Raiders Oakland 3 Colts Indianapolis 2 Dolphins Miami 2 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Colts Indianapolis 2 Colts Indianapolis 2 Colts Indianapolis 2 Vikings Minnesota 0 Colts Indianapolis 2 Bills Buffalo 0 Colts Indianapolis 2 Rams St. Louis 1 Colts Indianapolis 2 Chiefs Kansas City 1 Colts Indianapolis 2 Bears Chicago 1 Colts Indianapolis 2 Ravens Baltimore 1 Colts Indianapolis 2 Bengals Cincinnati 0 Colts Indianapolis 2 Eagles Philadelphia 0 Colts Indianapolis 2 Jets New York 1 Colts Indianapolis 2 Buccaneers Tampa Bay 1 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Colts Indianapolis 2 Saints New Orleans 1 Colts Indianapolis 2 Chargers San Diego 0 Colts Indianapolis 2 Falcons Atlanta 0 Colts Indianapolis 2 Titans Tennessee 0 Colts Indianapolis 2 Panthers Carolina 0 Colts Indianapolis 2 Seahawks Seattle 0 Colts Indianapolis 2 Cardinals Arizona 0 Colts Indianapolis 2 Browns Cleveland 0 Colts Indianapolis 2 Lions Detroit 0 Colts Indianapolis 2 Jaguars Jacksonville 0 Colts Indianapolis 2 Texans Houston 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Vikings Minnesota 0 Steelers Pittsburgh 6 Vikings Minnesota 0 Cowboys Dallas 5 Vikings Minnesota 0 Patriots New England 3 Vikings Minnesota 0 49ers San Francsico 5 Vikings Minnesota 0 Broncos Denver 2 Vikings Minnesota 0 Packers Green Bay 4 Vikings Minnesota 0 Giants New York 4 Vikings Minnesota 0 Redskins Washington 3 Vikings Minnesota 0 Raiders Oakland 3 Vikings Minnesota 0 Dolphins Miami 2 Vikings Minnesota 0 Colts Indianapolis 2 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Vikings Minnesota 0 Vikings Minnesota 0 Vikings Minnesota 0 Bills Buffalo 0 Vikings Minnesota 0 Rams St. Louis 1 Vikings Minnesota 0 Chiefs Kansas City 1 Vikings Minnesota 0 Bears Chicago 1 Vikings Minnesota 0 Ravens Baltimore 1 Vikings Minnesota 0 Bengals Cincinnati 0 Vikings Minnesota 0 Eagles Philadelphia 0 Vikings Minnesota 0 Jets New York 1 Vikings Minnesota 0 Buccaneers Tampa Bay 1 Vikings Minnesota 0 Saints New Orleans 1 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Vikings Minnesota 0 Chargers San Diego 0 Vikings Minnesota 0 Falcons Atlanta 0 Vikings Minnesota 0 Titans Tennessee 0 Vikings Minnesota 0 Panthers Carolina 0 Vikings Minnesota 0 Seahawks Seattle 0 Vikings Minnesota 0 Cardinals Arizona 0 Vikings Minnesota 0 Browns Cleveland 0 Vikings Minnesota 0 Lions Detroit 0 Vikings Minnesota 0 Jaguars Jacksonville 0 Vikings Minnesota 0 Texans Houston 0 Bills Buffalo 0 Steelers Pittsburgh 6 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Bills Buffalo 0 Cowboys Dallas 5 Bills Buffalo 0 Patriots New England 3 Bills Buffalo 0 49ers San Francsico 5 Bills Buffalo 0 Broncos Denver 2 Bills Buffalo 0 Packers Green Bay 4 Bills Buffalo 0 Giants New York 4 Bills Buffalo 0 Redskins Washington 3 Bills Buffalo 0 Raiders Oakland 3 Bills Buffalo 0 Dolphins Miami 2 Bills Buffalo 0 Colts Indianapolis 2 Bills Buffalo 0 Vikings Minnesota 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Bills Buffalo 0 Bills Buffalo 0 Bills Buffalo 0 Rams St. Louis 1 Bills Buffalo 0 Chiefs Kansas City 1 Bills Buffalo 0 Bears Chicago 1 Bills Buffalo 0 Ravens Baltimore 1 Bills Buffalo 0 Bengals Cincinnati 0 Bills Buffalo 0 Eagles Philadelphia 0 Bills Buffalo 0 Jets New York 1 Bills Buffalo 0 Buccaneers Tampa Bay 1 Bills Buffalo 0 Saints New Orleans 1 Bills Buffalo 0 Chargers San Diego 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Bills Buffalo 0 Falcons Atlanta 0 Bills Buffalo 0 Titans Tennessee 0 Bills Buffalo 0 Panthers Carolina 0 Bills Buffalo 0 Seahawks Seattle 0 Bills Buffalo 0 Cardinals Arizona 0 Bills Buffalo 0 Browns Cleveland 0 Bills Buffalo 0 Lions Detroit 0 Bills Buffalo 0 Jaguars Jacksonville 0 Bills Buffalo 0 Texans Houston 0 Rams St. Louis 1 Steelers Pittsburgh 6 Rams St. Louis 1 Cowboys Dallas 5 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Rams St. Louis 1 Patriots New England 3 Rams St. Louis 1 49ers San Francsico 5 Rams St. Louis 1 Broncos Denver 2 Rams St. Louis 1 Packers Green Bay 4 Rams St. Louis 1 Giants New York 4 Rams St. Louis 1 Redskins Washington 3 Rams St. Louis 1 Raiders Oakland 3 Rams St. Louis 1 Dolphins Miami 2 Rams St. Louis 1 Colts Indianapolis 2 Rams St. Louis 1 Vikings Minnesota 0 Rams St. Louis 1 Bills Buffalo 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Rams St. Louis 1 Rams St. Louis 1 Rams St. Louis 1 Chiefs Kansas City 1 Rams St. Louis 1 Bears Chicago 1 Rams St. Louis 1 Ravens Baltimore 1 Rams St. Louis 1 Bengals Cincinnati 0 Rams St. Louis 1 Eagles Philadelphia 0 Rams St. Louis 1 Jets New York 1 Rams St. Louis 1 Buccaneers Tampa Bay 1 Rams St. Louis 1 Saints New Orleans 1 Rams St. Louis 1 Chargers San Diego 0 Rams St. Louis 1 Falcons Atlanta 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Rams St. Louis 1 Titans Tennessee 0 Rams St. Louis 1 Panthers Carolina 0 Rams St. Louis 1 Seahawks Seattle 0 Rams St. Louis 1 Cardinals Arizona 0 Rams St. Louis 1 Browns Cleveland 0 Rams St. Louis 1 Lions Detroit 0 Rams St. Louis 1 Jaguars Jacksonville 0 Rams St. Louis 1 Texans Houston 0 Chiefs Kansas City 1 Steelers Pittsburgh 6 Chiefs Kansas City 1 Cowboys Dallas 5 Chiefs Kansas City 1 Patriots New England 3 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Chiefs Kansas City 1 49ers San Francsico 5 Chiefs Kansas City 1 Broncos Denver 2 Chiefs Kansas City 1 Packers Green Bay 4 Chiefs Kansas City 1 Giants New York 4 Chiefs Kansas City 1 Redskins Washington 3 Chiefs Kansas City 1 Raiders Oakland 3 Chiefs Kansas City 1 Dolphins Miami 2 Chiefs Kansas City 1 Colts Indianapolis 2 Chiefs Kansas City 1 Vikings Minnesota 0 Chiefs Kansas City 1 Bills Buffalo 0 Chiefs Kansas City 1 Rams St. Louis 1 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Chiefs Kansas City 1 Chiefs Kansas City 1 Chiefs Kansas City 1 Bears Chicago 1 Chiefs Kansas City 1 Ravens Baltimore 1 Chiefs Kansas City 1 Bengals Cincinnati 0 Chiefs Kansas City 1 Eagles Philadelphia 0 Chiefs Kansas City 1 Jets New York 1 Chiefs Kansas City 1 Buccaneers Tampa Bay 1 Chiefs Kansas City 1 Saints New Orleans 1 Chiefs Kansas City 1 Chargers San Diego 0 Chiefs Kansas City 1 Falcons Atlanta 0 Chiefs Kansas City 1 Titans Tennessee 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Chiefs Kansas City 1 Panthers Carolina 0 Chiefs Kansas City 1 Seahawks Seattle 0 Chiefs Kansas City 1 Cardinals Arizona 0 Chiefs Kansas City 1 Browns Cleveland 0 Chiefs Kansas City 1 Lions Detroit 0 Chiefs Kansas City 1 Jaguars Jacksonville 0 Chiefs Kansas City 1 Texans Houston 0 Bears Chicago 1 Steelers Pittsburgh 6 Bears Chicago 1 Cowboys Dallas 5 Bears Chicago 1 Patriots New England 3 Bears Chicago 1 49ers San Francsico 5 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Bears Chicago 1 Broncos Denver 2 Bears Chicago 1 Packers Green Bay 4 Bears Chicago 1 Giants New York 4 Bears Chicago 1 Redskins Washington 3 Bears Chicago 1 Raiders Oakland 3 Bears Chicago 1 Dolphins Miami 2 Bears Chicago 1 Colts Indianapolis 2 Bears Chicago 1 Vikings Minnesota 0 Bears Chicago 1 Bills Buffalo 0 Bears Chicago 1 Rams St. Louis 1 Bears Chicago 1 Chiefs Kansas City 1 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Bears Chicago 1 Bears Chicago 1 Bears Chicago 1 Ravens Baltimore 1 Bears Chicago 1 Bengals Cincinnati 0 Bears Chicago 1 Eagles Philadelphia 0 Bears Chicago 1 Jets New York 1 Bears Chicago 1 Buccaneers Tampa Bay 1 Bears Chicago 1 Saints New Orleans 1 Bears Chicago 1 Chargers San Diego 0 Bears Chicago 1 Falcons Atlanta 0 Bears Chicago 1 Titans Tennessee 0 Bears Chicago 1 Panthers Carolina 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Bears Chicago 1 Seahawks Seattle 0 Bears Chicago 1 Cardinals Arizona 0 Bears Chicago 1 Browns Cleveland 0 Bears Chicago 1 Lions Detroit 0 Bears Chicago 1 Jaguars Jacksonville 0 Bears Chicago 1 Texans Houston 0 Ravens Baltimore 1 Steelers Pittsburgh 6 Ravens Baltimore 1 Cowboys Dallas 5 Ravens Baltimore 1 Patriots New England 3 Ravens Baltimore 1 49ers San Francsico 5 Ravens Baltimore 1 Broncos Denver 2 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Ravens Baltimore 1 Packers Green Bay 4 Ravens Baltimore 1 Giants New York 4 Ravens Baltimore 1 Redskins Washington 3 Ravens Baltimore 1 Raiders Oakland 3 Ravens Baltimore 1 Dolphins Miami 2 Ravens Baltimore 1 Colts Indianapolis 2 Ravens Baltimore 1 Vikings Minnesota 0 Ravens Baltimore 1 Bills Buffalo 0 Ravens Baltimore 1 Rams St. Louis 1 Ravens Baltimore 1 Chiefs Kansas City 1 Ravens Baltimore 1 Bears Chicago 1 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Ravens Baltimore 1 Ravens Baltimore 1 Ravens Baltimore 1 Bengals Cincinnati 0 Ravens Baltimore 1 Eagles Philadelphia 0 Ravens Baltimore 1 Jets New York 1 Ravens Baltimore 1 Buccaneers Tampa Bay 1 Ravens Baltimore 1 Saints New Orleans 1 Ravens Baltimore 1 Chargers San Diego 0 Ravens Baltimore 1 Falcons Atlanta 0 Ravens Baltimore 1 Titans Tennessee 0 Ravens Baltimore 1 Panthers Carolina 0 Ravens Baltimore 1 Seahawks Seattle 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Ravens Baltimore 1 Cardinals Arizona 0 Ravens Baltimore 1 Browns Cleveland 0 Ravens Baltimore 1 Lions Detroit 0 Ravens Baltimore 1 Jaguars Jacksonville 0 Ravens Baltimore 1 Texans Houston 0 Bengals Cincinnati 0 Steelers Pittsburgh 6 Bengals Cincinnati 0 Cowboys Dallas 5 Bengals Cincinnati 0 Patriots New England 3 Bengals Cincinnati 0 49ers San Francsico 5 Bengals Cincinnati 0 Broncos Denver 2 Bengals Cincinnati 0 Packers Green Bay 4 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Bengals Cincinnati 0 Giants New York 4 Bengals Cincinnati 0 Redskins Washington 3 Bengals Cincinnati 0 Raiders Oakland 3 Bengals Cincinnati 0 Dolphins Miami 2 Bengals Cincinnati 0 Colts Indianapolis 2 Bengals Cincinnati 0 Vikings Minnesota 0 Bengals Cincinnati 0 Bills Buffalo 0 Bengals Cincinnati 0 Rams St. Louis 1 Bengals Cincinnati 0 Chiefs Kansas City 1 Bengals Cincinnati 0 Bears Chicago 1 Bengals Cincinnati 0 Ravens Baltimore 1 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Bengals Cincinnati 0 Bengals Cincinnati 0 Bengals Cincinnati 0 Eagles Philadelphia 0 Bengals Cincinnati 0 Jets New York 1 Bengals Cincinnati 0 Buccaneers Tampa Bay 1 Bengals Cincinnati 0 Saints New Orleans 1 Bengals Cincinnati 0 Chargers San Diego 0 Bengals Cincinnati 0 Falcons Atlanta 0 Bengals Cincinnati 0 Titans Tennessee 0 Bengals Cincinnati 0 Panthers Carolina 0 Bengals Cincinnati 0 Seahawks Seattle 0 Bengals Cincinnati 0 Cardinals Arizona 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Bengals Cincinnati 0 Browns Cleveland 0 Bengals Cincinnati 0 Lions Detroit 0 Bengals Cincinnati 0 Jaguars Jacksonville 0 Bengals Cincinnati 0 Texans Houston 0 Eagles Philadelphia 0 Steelers Pittsburgh 6 Eagles Philadelphia 0 Cowboys Dallas 5 Eagles Philadelphia 0 Patriots New England 3 Eagles Philadelphia 0 49ers San Francsico 5 Eagles Philadelphia 0 Broncos Denver 2 Eagles Philadelphia 0 Packers Green Bay 4 Eagles Philadelphia 0 Giants New York 4 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Eagles Philadelphia 0 Redskins Washington 3 Eagles Philadelphia 0 Raiders Oakland 3 Eagles Philadelphia 0 Dolphins Miami 2 Eagles Philadelphia 0 Colts Indianapolis 2 Eagles Philadelphia 0 Vikings Minnesota 0 Eagles Philadelphia 0 Bills Buffalo 0 Eagles Philadelphia 0 Rams St. Louis 1 Eagles Philadelphia 0 Chiefs Kansas City 1 Eagles Philadelphia 0 Bears Chicago 1 Eagles Philadelphia 0 Ravens Baltimore 1 Eagles Philadelphia 0 Bengals Cincinnati 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Eagles Philadelphia 0 Eagles Philadelphia 0 Eagles Philadelphia 0 Jets New York 1 Eagles Philadelphia 0 Buccaneers Tampa Bay 1 Eagles Philadelphia 0 Saints New Orleans 1 Eagles Philadelphia 0 Chargers San Diego 0 Eagles Philadelphia 0 Falcons Atlanta 0 Eagles Philadelphia 0 Titans Tennessee 0 Eagles Philadelphia 0 Panthers Carolina 0 Eagles Philadelphia 0 Seahawks Seattle 0 Eagles Philadelphia 0 Cardinals Arizona 0 Eagles Philadelphia 0 Browns Cleveland 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Eagles Philadelphia 0 Lions Detroit 0 Eagles Philadelphia 0 Jaguars Jacksonville 0 Eagles Philadelphia 0 Texans Houston 0 Jets New York 1 Steelers Pittsburgh 6 Jets New York 1 Cowboys Dallas 5 Jets New York 1 Patriots New England 3 Jets New York 1 49ers San Francsico 5 Jets New York 1 Broncos Denver 2 Jets New York 1 Packers Green Bay 4 Jets New York 1 Giants New York 4 Jets New York 1 Redskins Washington 3 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Jets New York 1 Raiders Oakland 3 Jets New York 1 Dolphins Miami 2 Jets New York 1 Colts Indianapolis 2 Jets New York 1 Vikings Minnesota 0 Jets New York 1 Bills Buffalo 0 Jets New York 1 Rams St. Louis 1 Jets New York 1 Chiefs Kansas City 1 Jets New York 1 Bears Chicago 1 Jets New York 1 Ravens Baltimore 1 Jets New York 1 Bengals Cincinnati 0 Jets New York 1 Eagles Philadelphia 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Jets New York 1 Jets New York 1 Jets New York 1 Buccaneers Tampa Bay 1 Jets New York 1 Saints New Orleans 1 Jets New York 1 Chargers San Diego 0 Jets New York 1 Falcons Atlanta 0 Jets New York 1 Titans Tennessee 0 Jets New York 1 Panthers Carolina 0 Jets New York 1 Seahawks Seattle 0 Jets New York 1 Cardinals Arizona 0 Jets New York 1 Browns Cleveland 0 Jets New York 1 Lions Detroit 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Jets New York 1 Jaguars Jacksonville 0 Jets New York 1 Texans Houston 0 Buccaneers Tampa Bay 1 Steelers Pittsburgh 6 Buccaneers Tampa Bay 1 Cowboys Dallas 5 Buccaneers Tampa Bay 1 Patriots New England 3 Buccaneers Tampa Bay 1 49ers San Francsico 5 Buccaneers Tampa Bay 1 Broncos Denver 2 Buccaneers Tampa Bay 1 Packers Green Bay 4 Buccaneers Tampa Bay 1 Giants New York 4 Buccaneers Tampa Bay 1 Redskins Washington 3 Buccaneers Tampa Bay 1 Raiders Oakland 3 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Buccaneers Tampa Bay 1 Dolphins Miami 2 Buccaneers Tampa Bay 1 Colts Indianapolis 2 Buccaneers Tampa Bay 1 Vikings Minnesota 0 Buccaneers Tampa Bay 1 Bills Buffalo 0 Buccaneers Tampa Bay 1 Rams St. Louis 1 Buccaneers Tampa Bay 1 Chiefs Kansas City 1 Buccaneers Tampa Bay 1 Bears Chicago 1 Buccaneers Tampa Bay 1 Ravens Baltimore 1 Buccaneers Tampa Bay 1 Bengals Cincinnati 0 Buccaneers Tampa Bay 1 Eagles Philadelphia 0 Buccaneers Tampa Bay 1 Jets New York 1 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Buccaneers Tampa Bay 1 Buccaneers Tampa Bay 1 Buccaneers Tampa Bay 1 Saints New Orleans 1 Buccaneers Tampa Bay 1 Chargers San Diego 0 Buccaneers Tampa Bay 1 Falcons Atlanta 0 Buccaneers Tampa Bay 1 Titans Tennessee 0 Buccaneers Tampa Bay 1 Panthers Carolina 0 Buccaneers Tampa Bay 1 Seahawks Seattle 0 Buccaneers Tampa Bay 1 Cardinals Arizona 0 Buccaneers Tampa Bay 1 Browns Cleveland 0 Buccaneers Tampa Bay 1 Lions Detroit 0 Buccaneers Tampa Bay 1 Jaguars Jacksonville 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Buccaneers Tampa Bay 1 Texans Houston 0 Saints New Orleans 1 Steelers Pittsburgh 6 Saints New Orleans 1 Cowboys Dallas 5 Saints New Orleans 1 Patriots New England 3 Saints New Orleans 1 49ers San Francsico 5 Saints New Orleans 1 Broncos Denver 2 Saints New Orleans 1 Packers Green Bay 4 Saints New Orleans 1 Giants New York 4 Saints New Orleans 1 Redskins Washington 3 Saints New Orleans 1 Raiders Oakland 3 Saints New Orleans 1 Dolphins Miami 2 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Saints New Orleans 1 Colts Indianapolis 2 Saints New Orleans 1 Vikings Minnesota 0 Saints New Orleans 1 Bills Buffalo 0 Saints New Orleans 1 Rams St. Louis 1 Saints New Orleans 1 Chiefs Kansas City 1 Saints New Orleans 1 Bears Chicago 1 Saints New Orleans 1 Ravens Baltimore 1 Saints New Orleans 1 Bengals Cincinnati 0 Saints New Orleans 1 Eagles Philadelphia 0 Saints New Orleans 1 Jets New York 1 Saints New Orleans 1 Buccaneers Tampa Bay 1 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Saints New Orleans 1 Saints New Orleans 1 Saints New Orleans 1 Chargers San Diego 0 Saints New Orleans 1 Falcons Atlanta 0 Saints New Orleans 1 Titans Tennessee 0 Saints New Orleans 1 Panthers Carolina 0 Saints New Orleans 1 Seahawks Seattle 0 Saints New Orleans 1 Cardinals Arizona 0 Saints New Orleans 1 Browns Cleveland 0 Saints New Orleans 1 Lions Detroit 0 Saints New Orleans 1 Jaguars Jacksonville 0 Saints New Orleans 1 Texans Houston 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Chargers San Diego 0 Steelers Pittsburgh 6 Chargers San Diego 0 Cowboys Dallas 5 Chargers San Diego 0 Patriots New England 3 Chargers San Diego 0 49ers San Francsico 5 Chargers San Diego 0 Broncos Denver 2 Chargers San Diego 0 Packers Green Bay 4 Chargers San Diego 0 Giants New York 4 Chargers San Diego 0 Redskins Washington 3 Chargers San Diego 0 Raiders Oakland 3 Chargers San Diego 0 Dolphins Miami 2 Chargers San Diego 0 Colts Indianapolis 2 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Chargers San Diego 0 Vikings Minnesota 0 Chargers San Diego 0 Bills Buffalo 0 Chargers San Diego 0 Rams St. Louis 1 Chargers San Diego 0 Chiefs Kansas City 1 Chargers San Diego 0 Bears Chicago 1 Chargers San Diego 0 Ravens Baltimore 1 Chargers San Diego 0 Bengals Cincinnati 0 Chargers San Diego 0 Eagles Philadelphia 0 Chargers San Diego 0 Jets New York 1 Chargers San Diego 0 Buccaneers Tampa Bay 1 Chargers San Diego 0 Saints New Orleans 1 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Chargers San Diego 0 Chargers San Diego 0 Chargers San Diego 0 Falcons Atlanta 0 Chargers San Diego 0 Titans Tennessee 0 Chargers San Diego 0 Panthers Carolina 0 Chargers San Diego 0 Seahawks Seattle 0 Chargers San Diego 0 Cardinals Arizona 0 Chargers San Diego 0 Browns Cleveland 0 Chargers San Diego 0 Lions Detroit 0 Chargers San Diego 0 Jaguars Jacksonville 0 Chargers San Diego 0 Texans Houston 0 Falcons Atlanta 0 Steelers Pittsburgh 6 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Falcons Atlanta 0 Cowboys Dallas 5 Falcons Atlanta 0 Patriots New England 3 Falcons Atlanta 0 49ers San Francsico 5 Falcons Atlanta 0 Broncos Denver 2 Falcons Atlanta 0 Packers Green Bay 4 Falcons Atlanta 0 Giants New York 4 Falcons Atlanta 0 Redskins Washington 3 Falcons Atlanta 0 Raiders Oakland 3 Falcons Atlanta 0 Dolphins Miami 2 Falcons Atlanta 0 Colts Indianapolis 2 Falcons Atlanta 0 Vikings Minnesota 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Falcons Atlanta 0 Bills Buffalo 0 Falcons Atlanta 0 Rams St. Louis 1 Falcons Atlanta 0 Chiefs Kansas City 1 Falcons Atlanta 0 Bears Chicago 1 Falcons Atlanta 0 Ravens Baltimore 1 Falcons Atlanta 0 Bengals Cincinnati 0 Falcons Atlanta 0 Eagles Philadelphia 0 Falcons Atlanta 0 Jets New York 1 Falcons Atlanta 0 Buccaneers Tampa Bay 1 Falcons Atlanta 0 Saints New Orleans 1 Falcons Atlanta 0 Chargers San Diego 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Falcons Atlanta 0 Falcons Atlanta 0 Falcons Atlanta 0 Titans Tennessee 0 Falcons Atlanta 0 Panthers Carolina 0 Falcons Atlanta 0 Seahawks Seattle 0 Falcons Atlanta 0 Cardinals Arizona 0 Falcons Atlanta 0 Browns Cleveland 0 Falcons Atlanta 0 Lions Detroit 0 Falcons Atlanta 0 Jaguars Jacksonville 0 Falcons Atlanta 0 Texans Houston 0 Titans Tennessee 0 Steelers Pittsburgh 6 Titans Tennessee 0 Cowboys Dallas 5 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Titans Tennessee 0 Patriots New England 3 Titans Tennessee 0 49ers San Francsico 5 Titans Tennessee 0 Broncos Denver 2 Titans Tennessee 0 Packers Green Bay 4 Titans Tennessee 0 Giants New York 4 Titans Tennessee 0 Redskins Washington 3 Titans Tennessee 0 Raiders Oakland 3 Titans Tennessee 0 Dolphins Miami 2 Titans Tennessee 0 Colts Indianapolis 2 Titans Tennessee 0 Vikings Minnesota 0 Titans Tennessee 0 Bills Buffalo 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Titans Tennessee 0 Rams St. Louis 1 Titans Tennessee 0 Chiefs Kansas City 1 Titans Tennessee 0 Bears Chicago 1 Titans Tennessee 0 Ravens Baltimore 1 Titans Tennessee 0 Bengals Cincinnati 0 Titans Tennessee 0 Eagles Philadelphia 0 Titans Tennessee 0 Jets New York 1 Titans Tennessee 0 Buccaneers Tampa Bay 1 Titans Tennessee 0 Saints New Orleans 1 Titans Tennessee 0 Chargers San Diego 0 Titans Tennessee 0 Falcons Atlanta 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Titans Tennessee 0 Titans Tennessee 0 Titans Tennessee 0 Panthers Carolina 0 Titans Tennessee 0 Seahawks Seattle 0 Titans Tennessee 0 Cardinals Arizona 0 Titans Tennessee 0 Browns Cleveland 0 Titans Tennessee 0 Lions Detroit 0 Titans Tennessee 0 Jaguars Jacksonville 0 Titans Tennessee 0 Texans Houston 0 Panthers Carolina 0 Steelers Pittsburgh 6 Panthers Carolina 0 Cowboys Dallas 5 Panthers Carolina 0 Patriots New England 3 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Panthers Carolina 0 49ers San Francsico 5 Panthers Carolina 0 Broncos Denver 2 Panthers Carolina 0 Packers Green Bay 4 Panthers Carolina 0 Giants New York 4 Panthers Carolina 0 Redskins Washington 3 Panthers Carolina 0 Raiders Oakland 3 Panthers Carolina 0 Dolphins Miami 2 Panthers Carolina 0 Colts Indianapolis 2 Panthers Carolina 0 Vikings Minnesota 0 Panthers Carolina 0 Bills Buffalo 0 Panthers Carolina 0 Rams St. Louis 1 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Panthers Carolina 0 Chiefs Kansas City 1 Panthers Carolina 0 Bears Chicago 1 Panthers Carolina 0 Ravens Baltimore 1 Panthers Carolina 0 Bengals Cincinnati 0 Panthers Carolina 0 Eagles Philadelphia 0 Panthers Carolina 0 Jets New York 1 Panthers Carolina 0 Buccaneers Tampa Bay 1 Panthers Carolina 0 Saints New Orleans 1 Panthers Carolina 0 Chargers San Diego 0 Panthers Carolina 0 Falcons Atlanta 0 Panthers Carolina 0 Titans Tennessee 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Panthers Carolina 0 Panthers Carolina 0 Panthers Carolina 0 Seahawks Seattle 0 Panthers Carolina 0 Cardinals Arizona 0 Panthers Carolina 0 Browns Cleveland 0 Panthers Carolina 0 Lions Detroit 0 Panthers Carolina 0 Jaguars Jacksonville 0 Panthers Carolina 0 Texans Houston 0 Seahawks Seattle 0 Steelers Pittsburgh 6 Seahawks Seattle 0 Cowboys Dallas 5 Seahawks Seattle 0 Patriots New England 3 Seahawks Seattle 0 49ers San Francsico 5 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Seahawks Seattle 0 Broncos Denver 2 Seahawks Seattle 0 Packers Green Bay 4 Seahawks Seattle 0 Giants New York 4 Seahawks Seattle 0 Redskins Washington 3 Seahawks Seattle 0 Raiders Oakland 3 Seahawks Seattle 0 Dolphins Miami 2 Seahawks Seattle 0 Colts Indianapolis 2 Seahawks Seattle 0 Vikings Minnesota 0 Seahawks Seattle 0 Bills Buffalo 0 Seahawks Seattle 0 Rams St. Louis 1 Seahawks Seattle 0 Chiefs Kansas City 1 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Seahawks Seattle 0 Bears Chicago 1 Seahawks Seattle 0 Ravens Baltimore 1 Seahawks Seattle 0 Bengals Cincinnati 0 Seahawks Seattle 0 Eagles Philadelphia 0 Seahawks Seattle 0 Jets New York 1 Seahawks Seattle 0 Buccaneers Tampa Bay 1 Seahawks Seattle 0 Saints New Orleans 1 Seahawks Seattle 0 Chargers San Diego 0 Seahawks Seattle 0 Falcons Atlanta 0 Seahawks Seattle 0 Titans Tennessee 0 Seahawks Seattle 0 Panthers Carolina 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Seahawks Seattle 0 Seahawks Seattle 0 Seahawks Seattle 0 Cardinals Arizona 0 Seahawks Seattle 0 Browns Cleveland 0 Seahawks Seattle 0 Lions Detroit 0 Seahawks Seattle 0 Jaguars Jacksonville 0 Seahawks Seattle 0 Texans Houston 0 Cardinals Arizona 0 Steelers Pittsburgh 6 Cardinals Arizona 0 Cowboys Dallas 5 Cardinals Arizona 0 Patriots New England 3 Cardinals Arizona 0 49ers San Francsico 5 Cardinals Arizona 0 Broncos Denver 2 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Cardinals Arizona 0 Packers Green Bay 4 Cardinals Arizona 0 Giants New York 4 Cardinals Arizona 0 Redskins Washington 3 Cardinals Arizona 0 Raiders Oakland 3 Cardinals Arizona 0 Dolphins Miami 2 Cardinals Arizona 0 Colts Indianapolis 2 Cardinals Arizona 0 Vikings Minnesota 0 Cardinals Arizona 0 Bills Buffalo 0 Cardinals Arizona 0 Rams St. Louis 1 Cardinals Arizona 0 Chiefs Kansas City 1 Cardinals Arizona 0 Bears Chicago 1 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Cardinals Arizona 0 Ravens Baltimore 1 Cardinals Arizona 0 Bengals Cincinnati 0 Cardinals Arizona 0 Eagles Philadelphia 0 Cardinals Arizona 0 Jets New York 1 Cardinals Arizona 0 Buccaneers Tampa Bay 1 Cardinals Arizona 0 Saints New Orleans 1 Cardinals Arizona 0 Chargers San Diego 0 Cardinals Arizona 0 Falcons Atlanta 0 Cardinals Arizona 0 Titans Tennessee 0 Cardinals Arizona 0 Panthers Carolina 0 Cardinals Arizona 0 Seahawks Seattle 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Cardinals Arizona 0 Cardinals Arizona 0 Cardinals Arizona 0 Browns Cleveland 0 Cardinals Arizona 0 Lions Detroit 0 Cardinals Arizona 0 Jaguars Jacksonville 0 Cardinals Arizona 0 Texans Houston 0 Browns Cleveland 0 Steelers Pittsburgh 6 Browns Cleveland 0 Cowboys Dallas 5 Browns Cleveland 0 Patriots New England 3 Browns Cleveland 0 49ers San Francsico 5 Browns Cleveland 0 Broncos Denver 2 Browns Cleveland 0 Packers Green Bay 4 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Browns Cleveland 0 Giants New York 4 Browns Cleveland 0 Redskins Washington 3 Browns Cleveland 0 Raiders Oakland 3 Browns Cleveland 0 Dolphins Miami 2 Browns Cleveland 0 Colts Indianapolis 2 Browns Cleveland 0 Vikings Minnesota 0 Browns Cleveland 0 Bills Buffalo 0 Browns Cleveland 0 Rams St. Louis 1 Browns Cleveland 0 Chiefs Kansas City 1 Browns Cleveland 0 Bears Chicago 1 Browns Cleveland 0 Ravens Baltimore 1 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Browns Cleveland 0 Bengals Cincinnati 0 Browns Cleveland 0 Eagles Philadelphia 0 Browns Cleveland 0 Jets New York 1 Browns Cleveland 0 Buccaneers Tampa Bay 1 Browns Cleveland 0 Saints New Orleans 1 Browns Cleveland 0 Chargers San Diego 0 Browns Cleveland 0 Falcons Atlanta 0 Browns Cleveland 0 Titans Tennessee 0 Browns Cleveland 0 Panthers Carolina 0 Browns Cleveland 0 Seahawks Seattle 0 Browns Cleveland 0 Cardinals Arizona 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Browns Cleveland 0 Browns Cleveland 0 Browns Cleveland 0 Lions Detroit 0 Browns Cleveland 0 Jaguars Jacksonville 0 Browns Cleveland 0 Texans Houston 0 Lions Detroit 0 Steelers Pittsburgh 6 Lions Detroit 0 Cowboys Dallas 5 Lions Detroit 0 Patriots New England 3 Lions Detroit 0 49ers San Francsico 5 Lions Detroit 0 Broncos Denver 2 Lions Detroit 0 Packers Green Bay 4 Lions Detroit 0 Giants New York 4 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Lions Detroit 0 Redskins Washington 3 Lions Detroit 0 Raiders Oakland 3 Lions Detroit 0 Dolphins Miami 2 Lions Detroit 0 Colts Indianapolis 2 Lions Detroit 0 Vikings Minnesota 0 Lions Detroit 0 Bills Buffalo 0 Lions Detroit 0 Rams St. Louis 1 Lions Detroit 0 Chiefs Kansas City 1 Lions Detroit 0 Bears Chicago 1 Lions Detroit 0 Ravens Baltimore 1 Lions Detroit 0 Bengals Cincinnati 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Lions Detroit 0 Eagles Philadelphia 0 Lions Detroit 0 Jets New York 1 Lions Detroit 0 Buccaneers Tampa Bay 1 Lions Detroit 0 Saints New Orleans 1 Lions Detroit 0 Chargers San Diego 0 Lions Detroit 0 Falcons Atlanta 0 Lions Detroit 0 Titans Tennessee 0 Lions Detroit 0 Panthers Carolina 0 Lions Detroit 0 Seahawks Seattle 0 Lions Detroit 0 Cardinals Arizona 0 Lions Detroit 0 Browns Cleveland 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Lions Detroit 0 Lions Detroit 0 Lions Detroit 0 Jaguars Jacksonville 0 Lions Detroit 0 Texans Houston 0 Jaguars Jacksonville 0 Steelers Pittsburgh 6 Jaguars Jacksonville 0 Cowboys Dallas 5 Jaguars Jacksonville 0 Patriots New England 3 Jaguars Jacksonville 0 49ers San Francsico 5 Jaguars Jacksonville 0 Broncos Denver 2 Jaguars Jacksonville 0 Packers Green Bay 4 Jaguars Jacksonville 0 Giants New York 4 Jaguars Jacksonville 0 Redskins Washington 3 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Jaguars Jacksonville 0 Raiders Oakland 3 Jaguars Jacksonville 0 Dolphins Miami 2 Jaguars Jacksonville 0 Colts Indianapolis 2 Jaguars Jacksonville 0 Vikings Minnesota 0 Jaguars Jacksonville 0 Bills Buffalo 0 Jaguars Jacksonville 0 Rams St. Louis 1 Jaguars Jacksonville 0 Chiefs Kansas City 1 Jaguars Jacksonville 0 Bears Chicago 1 Jaguars Jacksonville 0 Ravens Baltimore 1 Jaguars Jacksonville 0 Bengals Cincinnati 0 Jaguars Jacksonville 0 Eagles Philadelphia 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Jaguars Jacksonville 0 Jets New York 1 Jaguars Jacksonville 0 Buccaneers Tampa Bay 1 Jaguars Jacksonville 0 Saints New Orleans 1 Jaguars Jacksonville 0 Chargers San Diego 0 Jaguars Jacksonville 0 Falcons Atlanta 0 Jaguars Jacksonville 0 Titans Tennessee 0 Jaguars Jacksonville 0 Panthers Carolina 0 Jaguars Jacksonville 0 Seahawks Seattle 0 Jaguars Jacksonville 0 Cardinals Arizona 0 Jaguars Jacksonville 0 Browns Cleveland 0 Jaguars Jacksonville 0 Lions Detroit 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Jaguars Jacksonville 0 Jaguars Jacksonville 0 Jaguars Jacksonville 0 Texans Houston 0 Texans Houston 0 Steelers Pittsburgh 6 Texans Houston 0 Cowboys Dallas 5 Texans Houston 0 Patriots New England 3 Texans Houston 0 49ers San Francsico 5 Texans Houston 0 Broncos Denver 2 Texans Houston 0 Packers Green Bay 4 Texans Houston 0 Giants New York 4 Texans Houston 0 Redskins Washington 3 Texans Houston 0 Raiders Oakland 3 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Texans Houston 0 Dolphins Miami 2 Texans Houston 0 Colts Indianapolis 2 Texans Houston 0 Vikings Minnesota 0 Texans Houston 0 Bills Buffalo 0 Texans Houston 0 Rams St. Louis 1 Texans Houston 0 Chiefs Kansas City 1 Texans Houston 0 Bears Chicago 1 Texans Houston 0 Ravens Baltimore 1 Texans Houston 0 Bengals Cincinnati 0 Texans Houston 0 Eagles Philadelphia 0 Texans Houston 0 Jets New York 1 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Texans Houston 0 Buccaneers Tampa Bay 1 Texans Houston 0 Saints New Orleans 1 Texans Houston 0 Chargers San Diego 0 Texans Houston 0 Falcons Atlanta 0 Texans Houston 0 Titans Tennessee 0 Texans Houston 0 Panthers Carolina 0 Texans Houston 0 Seahawks Seattle 0 Texans Houston 0 Cardinals Arizona 0 Texans Houston 0 Browns Cleveland 0 Texans Houston 0 Lions Detroit 0 Texans Houston 0 Jaguars Jacksonville 0 TEAMNAME LOCATION SUPERBOWLWINS TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- -------------------- -------------------- ------------- Texans Houston 0 Texans Houston 0 1024 rows selected. SQL> select * from teams where superbowlwins = 5; TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- Cowboys Dallas 5 49ers San Francsico 5 SQL> select t.* 2 from teams t, teams sf 3 where sf.teamname = '49ers' and t.superbowlwins > sf.superbowlwins; TEAMNAME LOCATION SUPERBOWLWINS -------------------- -------------------- ------------- Steelers Pittsburgh 6 SQL> select teamname, location from teams where superbowlwins > 3; TEAMNAME LOCATION -------------------- -------------------- Steelers Pittsburgh Cowboys Dallas 49ers San Francsico Packers Green Bay Giants New York SQL> select location, location, teamname from teams where superbowlwins > 3; LOCATION LOCATION TEAMNAME -------------------- -------------------- -------------------- Pittsburgh Pittsburgh Steelers Dallas Dallas Cowboys San Francsico San Francsico 49ers Green Bay Green Bay Packers New York New York Giants SQL> select superbowlwins * 20 from teams; SUPERBOWLWINS*20 ---------------- 120 100 60 100 40 80 80 60 60 40 40 SUPERBOWLWINS*20 ---------------- 0 0 20 20 20 20 0 0 20 20 20 SUPERBOWLWINS*20 ---------------- 0 0 0 0 0 0 0 0 0 0 32 rows selected. SQL> select lower(teamname), upper(location) from teams; LOWER(TEAMNAME) UPPER(LOCATION) -------------------- -------------------- steelers PITTSBURGH cowboys DALLAS patriots NEW ENGLAND 49ers SAN FRANCSICO broncos DENVER packers GREEN BAY giants NEW YORK redskins WASHINGTON raiders OAKLAND dolphins MIAMI colts INDIANAPOLIS LOWER(TEAMNAME) UPPER(LOCATION) -------------------- -------------------- vikings MINNESOTA bills BUFFALO rams ST. LOUIS chiefs KANSAS CITY bears CHICAGO ravens BALTIMORE bengals CINCINNATI eagles PHILADELPHIA jets NEW YORK buccaneers TAMPA BAY saints NEW ORLEANS LOWER(TEAMNAME) UPPER(LOCATION) -------------------- -------------------- chargers SAN DIEGO falcons ATLANTA titans TENNESSEE panthers CAROLINA seahawks SEATTLE cardinals ARIZONA browns CLEVELAND lions DETROIT jaguars JACKSONVILLE texans HOUSTON 32 rows selected. SQL> select * from poke; POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 399 Bidoof normal 200 5 58 400 Bibarel normal 315 10 116 424 Ambipom normal 203 12 186 427 Buneary normal 55 4 84 428 Lopunny normal 333 12 178 431 Glameow normal 39 5 71 432 Purugly normal 438 10 183 440 Happiny normal 244 6 255 441 Chatot normal 19 5 107 446 Munchlax normal 1050 6 94 463 Lickilicky normal 1400 17 193 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 468 Togekiss normal 380 15 220 474 Porygon-Z normal 340 9 185 486 Regigigas normal 4200 37 220 493 Arceus normal 3200 32 255 504 Patrat normal 116 5 51 505 Watchog normal 270 11 147 506 Lillipup normal 41 4 55 507 Herdier normal 147 9 130 508 Stoutland normal 610 12 221 519 Pidove normal 21 3 53 520 Tranquill normal 150 6 125 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 521 Unfezant normal 290 12 215 531 Audino normal 310 11 390 572 Minccino normal 58 4 60 573 Cinccino normal 75 5 165 585 Deerling normal 195 6 67 586 Sawsbuck normal 925 19 166 626 Bouffalant normal 946 16 172 627 Rufflet normal 105 5 70 628 Braviary normal 410 15 179 648 Meloetta normal 65 6 270 16 Pidgey normal 18 3 55 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 17 Pidgeotto normal 300 11 113 18 Pidgeot normal 395 15 172 19 Rattata normal 35 3 57 20 Raticate normal 185 7 116 21 Spearow normal 20 3 58 22 Fearow normal 380 12 162 35 Clefairy normal 75 6 68 36 Clefable normal 400 13 129 39 Jigglypuff normal 55 5 76 40 Wigglytuff normal 120 10 109 52 Meowth normal 42 4 69 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 53 Persian normal 320 10 148 84 Doduo normal 392 14 96 85 Dodrio normal 852 18 158 108 Lickitung normal 655 12 127 113 Chansey normal 346 11 255 115 Kangaskhan normal 800 22 175 128 Tauros normal 884 14 211 132 Ditto normal 40 3 61 133 Eevee normal 65 3 92 137 Porygon normal 365 8 130 143 Snorlax normal 4600 21 154 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 161 Sentret normal 60 8 57 162 Furret normal 325 18 116 163 Hoothoot normal 212 7 58 164 Noctowl normal 408 16 162 173 Cleffa normal 30 3 37 174 Igglybuff normal 10 3 39 175 Togepi normal 15 3 74 176 Togetic normal 32 6 114 190 Aipom normal 115 8 94 203 Girafarig normal 415 15 149 206 Dunsparce normal 140 15 125 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 209 Snubbull normal 78 6 63 210 Granbull normal 487 14 178 216 Teddiursa normal 88 6 124 217 Ursaring normal 1258 18 189 233 Porygon2 normal 325 6 180 234 Stantler normal 712 14 165 235 Smeargle normal 580 12 106 241 Miltank normal 755 12 200 242 Blissey normal 468 15 255 263 Zigzagoon normal 175 4 60 264 Linoone normal 325 5 128 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 276 Taillow normal 23 3 59 277 Swellow normal 198 7 162 287 Slakoth normal 240 8 83 288 Vigoroth normal 465 14 126 289 Slaking normal 1305 20 210 293 Whismur normal 163 6 68 294 Loudred normal 405 10 126 295 Exploud normal 840 15 184 298 Azurill normal 20 2 33 300 Skitty normal 110 6 65 301 Delcatty normal 326 11 138 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 327 Spinda normal 50 11 85 333 Swablu normal 12 4 74 335 Zangoose normal 403 13 165 351 Castform normal 8 3 145 352 Kecleon normal 220 10 132 396 Starly normal 20 3 56 397 Staravia normal 155 6 113 398 Staraptor normal 249 12 172 56 Mankey fighting 280 5 74 57 Primeape fighting 320 10 149 66 Machop fighting 195 8 75 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 67 Machoke fighting 705 15 146 68 Machamp fighting 1300 16 193 106 Hitmonlee fighting 498 15 139 107 Hitmonchan fighting 502 14 140 236 Tyrogue fighting 210 7 91 237 Hitmontop fighting 480 14 138 296 Makuhita fighting 864 10 87 297 Hariyama fighting 2538 23 184 307 Meditite fighting 112 6 91 308 Medicham fighting 315 13 153 447 Riolu fighting 202 7 72 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 448 Lucario fighting 540 12 204 532 Timburr fighting 125 6 61 533 Gurdurr fighting 400 12 142 534 Conkeldurr fighting 870 14 227 538 Throh fighting 555 13 163 539 Sawk fighting 510 14 163 619 Mienfoo fighting 200 9 70 620 Mienshao fighting 355 14 179 641 Tornadus flying 630 15 261 23 Ekans poison 69 20 62 24 Arbok poison 650 35 147 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 29 Nidoran??? poison 70 4 59 30 Nidorina poison 200 8 117 31 Nidoqueen poison 600 13 194 33 Nidorino poison 195 9 118 34 Nidoking poison 620 14 195 41 Zubat poison 75 8 54 42 Golbat poison 550 16 171 88 Grimer poison 300 9 90 89 Muk poison 300 12 157 109 Koffing poison 10 6 114 110 Weezing poison 95 12 173 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 169 Crobat poison 750 18 204 316 Gulpin poison 103 4 75 317 Swalot poison 800 17 168 336 Seviper poison 525 27 165 434 Stunky poison 192 4 79 435 Skuntank poison 380 10 209 451 Skorupi poison 120 8 114 452 Drapion poison 615 13 204 453 Croagunk poison 230 7 83 454 Toxicroak poison 444 13 181 568 Trubbish poison 310 6 66 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 569 Garbodor poison 1073 19 166 27 Sandshrew ground 120 6 93 28 Sandslash ground 295 10 163 50 Diglett ground 8 2 81 51 Dugtrio ground 333 7 153 104 Cubone ground 65 4 87 105 Marowak ground 450 10 124 111 Rhyhorn ground 1150 10 135 112 Rhydon ground 1200 19 204 207 Gligar ground 648 11 108 231 Phanpy ground 335 5 124 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 232 Donphan ground 1200 11 189 328 Trapinch ground 150 7 73 329 Vibrava ground 153 11 126 330 Flygon ground 820 20 197 343 Baltoy ground 215 5 58 344 Claydol ground 1080 15 189 383 Groudon ground 9500 35 218 449 Hippopotas ground 495 8 95 450 Hippowdon ground 3000 20 198 464 Rhyperior ground 2828 24 217 472 Gliscor ground 425 20 192 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 529 Drilbur ground 85 3 66 530 Excadrill ground 404 7 178 551 Sandile ground 152 7 58 552 Krokorok ground 334 10 123 553 Krookodile ground 963 15 229 618 Stunfisk ground 110 7 165 622 Golett ground 920 10 61 623 Golurk ground 3300 28 169 645 Landorus ground 680 15 270 74 Geodude rock 200 4 73 75 Graveler rock 1050 10 134 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 76 Golem rock 3000 14 177 95 Onix rock 2100 88 108 138 Omanyte rock 75 4 99 139 Omastar rock 350 10 199 140 Kabuto rock 115 5 99 141 Kabutops rock 405 13 199 142 Aerodactyl rock 590 18 202 185 Sudowoodo rock 380 12 135 246 Larvitar rock 720 6 67 247 Pupitar rock 1520 12 144 248 Tyranitar rock 2020 20 218 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 299 Nosepass rock 970 10 108 337 Lunatone rock 1680 10 150 338 Solrock rock 1540 12 150 345 Lileep rock 238 10 99 346 Cradily rock 604 15 199 347 Anorith rock 125 7 99 348 Armaldo rock 682 15 199 377 Regirock rock 2300 17 217 408 Cranidos rock 315 9 99 409 Rampardos rock 1025 16 199 410 Shieldon rock 570 5 99 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 411 Bastiodon rock 1495 13 199 438 Bonsly rock 150 5 68 476 Probopass rock 3400 14 198 524 Roggenrola rock 180 4 56 525 Boldore rock 1020 9 137 526 Gigalith rock 2600 17 227 566 Archen rock 95 5 71 567 Archeops rock 320 14 177 639 Terrakion rock 2600 19 261 10 Caterpie bug 29 3 53 11 Metapod bug 99 7 72 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 12 Butterfree bug 320 11 160 13 Weedle bug 32 3 52 14 Kakuna bug 100 6 71 15 Beedrill bug 295 10 159 46 Paras bug 54 3 70 47 Parasect bug 295 10 128 48 Venonat bug 300 10 75 49 Venomoth bug 125 15 138 123 Scyther bug 560 15 187 127 Pinsir bug 550 15 200 165 Ledyba bug 108 10 54 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 166 Ledian bug 356 14 134 167 Spinarak bug 85 5 54 168 Ariados bug 335 11 134 193 Yanma bug 380 12 147 204 Pineco bug 72 6 60 205 Forretress bug 1258 12 118 212 Scizor bug 1180 18 200 213 Shuckle bug 205 6 80 214 Heracross bug 540 15 200 265 Wurmple bug 36 3 54 266 Silcoon bug 100 6 72 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 267 Beautifly bug 284 10 161 268 Cascoon bug 115 7 72 269 Dustox bug 316 12 161 283 Surskit bug 17 5 63 284 Masquerain bug 36 8 128 290 Nincada bug 55 5 65 291 Ninjask bug 120 8 155 292 Shedinja bug 12 8 95 313 Volbeat bug 177 7 146 314 Illumise bug 177 6 146 401 Kricketot bug 22 3 54 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 402 Kricketune bug 255 10 159 412 Burmy bug 34 2 61 413 Wormadam bug 65 5 159 414 Mothim bug 233 9 159 415 Combee bug 55 3 63 416 Vespiquen bug 385 12 188 469 Yanmega bug 515 19 198 540 Sewaddle bug 25 3 62 541 Swadloon bug 73 5 133 542 Leavanny bug 205 12 221 543 Venipede bug 53 4 52 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 544 Whirlipede bug 585 12 126 545 Scolipede bug 2005 25 214 557 Dwebble bug 145 3 65 558 Crustle bug 2000 14 166 588 Karrablast bug 59 5 63 589 Escavalier bug 330 10 173 595 Joltik bug 6 1 64 596 Galvantula bug 143 8 165 616 Shelmet bug 77 4 61 617 Accelgor bug 253 8 173 632 Durant bug 330 3 169 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 636 Larvesta bug 288 11 72 637 Volcarona bug 460 16 248 649 Genesect bug 825 15 270 92 Gastly ghost 1 13 95 93 Haunter ghost 1 16 126 94 Gengar ghost 405 15 190 200 Misdreavus ghost 10 7 147 353 Shuppet ghost 23 6 97 354 Banette ghost 125 11 179 355 Duskull ghost 150 8 97 356 Dusclops ghost 306 16 179 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 425 Drifloon ghost 12 4 127 426 Drifblim ghost 150 12 204 429 Mismagius ghost 44 9 187 442 Spiritomb ghost 1080 10 168 477 Dusknoir ghost 1066 22 210 487 Giratina ghost 7500 45 220 562 Yamask ghost 15 5 61 563 Cofagrigus ghost 765 17 169 607 Litwick ghost 31 3 55 608 Lampent ghost 130 6 130 609 Chandelure ghost 343 10 234 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 208 Steelix steel 4000 92 196 227 Skarmory steel 505 17 168 303 Mawile steel 115 6 98 304 Aron steel 600 4 96 305 Lairon steel 1200 9 152 306 Aggron steel 3600 21 205 374 Beldum steel 952 6 103 375 Metang steel 2025 12 153 376 Metagross steel 5500 16 210 379 Registeel steel 2050 19 215 385 Jirachi steel 11 3 215 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 436 Bronzor steel 605 5 72 437 Bronzong steel 1870 13 188 483 Dialga steel 6830 54 220 599 Klink steel 210 3 60 600 Klang steel 510 6 154 601 Klinklang steel 810 6 234 638 Cobalion steel 2500 21 261 4 Charmander fire 85 6 65 5 Charmeleon fire 190 11 142 6 Charizard fire 905 17 209 37 Vulpix fire 99 6 63 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 38 Ninetales fire 199 11 178 58 Growlithe fire 190 7 91 59 Arcanine fire 1550 19 213 77 Ponyta fire 300 10 152 78 Rapidash fire 950 17 192 126 Magmar fire 445 13 167 136 Flareon fire 250 9 198 146 Moltres fire 600 20 217 155 Cyndaquil fire 79 5 65 156 Quilava fire 190 9 142 157 Typhlosion fire 795 17 209 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 218 Slugma fire 350 7 78 219 Magcargo fire 550 8 154 240 Magby fire 214 7 117 244 Entei fire 1980 21 217 250 Ho-Oh fire 1990 38 220 255 Torchic fire 25 4 65 256 Combusken fire 195 9 142 257 Blaziken fire 520 19 209 322 Numel fire 240 7 88 323 Camerupt fire 2200 19 175 324 Torkoal fire 804 5 161 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 390 Chimchar fire 62 5 65 391 Monferno fire 220 9 142 392 Infernape fire 550 12 209 467 Magmortar fire 680 16 199 485 Heatran fire 4300 17 215 498 Tepig fire 99 5 28 499 Pignite fire 555 10 146 500 Emboar fire 1500 16 238 513 Pansear fire 110 6 63 514 Simisear fire 280 10 174 554 Darumaka fire 375 6 63 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 555 Darmanitan fire 929 13 168 631 Heatmor fire 580 14 169 366 Clamperl water 525 4 142 367 Huntail water 270 17 178 368 Gorebyss water 226 18 178 369 Relicanth water 234 10 198 370 Luvdisc water 87 6 110 382 Kyogre water 3520 45 218 393 Piplup water 52 4 66 394 Prinplup water 230 8 143 395 Empoleon water 845 17 210 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 418 Buizel water 295 7 75 419 Floatzel water 335 11 178 422 Shellos water 63 3 73 423 Gastrodon water 299 9 176 456 Finneon water 70 4 90 457 Lumineon water 240 12 156 458 Mantyke water 650 10 108 484 Palkia water 3360 42 220 489 Phione water 31 4 165 490 Manaphy water 14 3 215 501 Oshawott water 59 5 28 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 502 Dewott water 245 8 145 503 Samurott water 946 15 238 515 Panpour water 135 6 63 516 Simipour water 290 10 174 535 Tympole water 45 5 59 536 Palpitoad water 170 8 134 537 Seismitoad water 620 15 225 550 Basculin water 180 10 161 564 Tirtouga water 165 7 71 565 Carracosta water 810 12 173 580 Ducklett water 55 5 61 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 581 Swanna water 242 13 166 592 Frillish water 330 12 67 593 Jellicent water 1350 22 168 594 Alomomola water 316 12 165 647 Keldeo water 485 14 261 7 Squirtle water 90 5 66 8 Wartortle water 225 10 143 9 Blastoise water 855 16 210 54 Psyduck water 196 8 80 55 Golduck water 766 17 174 60 Poliwag water 124 6 77 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 61 Poliwhirl water 200 10 131 62 Poliwrath water 540 13 185 72 Tentacool water 455 9 105 73 Tentacruel water 550 16 205 79 Slowpoke water 360 12 99 80 Slowbro water 785 16 164 86 Seel water 900 11 100 87 Dewgong water 1200 17 176 90 Shellder water 40 3 97 91 Cloyster water 1325 15 203 98 Krabby water 65 4 115 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 99 Kingler water 600 13 206 116 Horsea water 80 4 83 117 Seadra water 250 12 155 118 Goldeen water 150 6 111 119 Seaking water 390 13 170 120 Staryu water 345 8 106 121 Starmie water 800 11 207 129 Magikarp water 100 9 20 130 Gyarados water 2350 65 214 131 Lapras water 2200 25 219 134 Vaporeon water 290 10 196 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 158 Totodile water 95 6 66 159 Croconaw water 250 11 143 160 Feraligatr water 888 23 210 170 Chinchou water 120 5 90 171 Lanturn water 225 12 156 183 Marill water 85 4 58 184 Azumarill water 285 8 153 186 Politoed water 339 11 185 194 Wooper water 85 4 52 195 Quagsire water 750 14 137 199 Slowking water 795 20 164 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 211 Qwilfish water 39 5 100 222 Corsola water 50 6 113 223 Remoraid water 120 6 78 224 Octillery water 285 9 164 226 Mantine water 2200 21 168 230 Kingdra water 1520 18 207 245 Suicune water 1870 20 215 258 Mudkip water 76 4 65 259 Marshtomp water 280 7 143 260 Swampert water 819 15 210 270 Lotad water 26 5 74 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 271 Lombre water 325 12 141 272 Ludicolo water 550 15 181 278 Wingull water 95 6 64 279 Pelipper water 280 12 164 318 Carvanha water 208 8 88 319 Sharpedo water 888 18 175 320 Wailmer water 1300 20 137 321 Wailord water 3980 145 206 339 Barboach water 19 4 92 340 Whiscash water 236 9 158 341 Corphish water 115 6 111 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 342 Crawdaunt water 328 11 161 349 Feebas water 74 6 61 350 Milotic water 1620 62 213 1 Bulbasaur grass 69 7 64 2 Ivysaur grass 130 10 141 3 Venusaur grass 1000 20 208 43 Oddish grass 54 5 78 44 Gloom grass 86 8 132 45 Vileplume grass 186 12 184 69 Bellsprout grass 40 7 84 70 Weepinbell grass 64 10 151 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 71 Victreebel grass 155 17 191 102 Exeggcute grass 25 4 98 103 Exeggutor grass 1200 20 212 114 Tangela grass 350 10 166 152 Chikorita grass 64 9 64 153 Bayleef grass 158 12 141 154 Meganium grass 1005 18 208 182 Bellossom grass 58 4 184 187 Hoppip grass 5 4 74 188 Skiploom grass 10 6 136 189 Jumpluff grass 30 8 176 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 191 Sunkern grass 18 3 52 192 Sunflora grass 85 8 146 252 Treecko grass 50 5 65 253 Grovyle grass 216 9 141 254 Sceptile grass 522 17 208 273 Seedot grass 40 5 74 274 Nuzleaf grass 280 10 141 275 Shiftry grass 596 13 181 285 Shroomish grass 45 4 65 286 Breloom grass 392 12 165 315 Roselia grass 20 3 152 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 331 Cacnea grass 513 4 97 332 Cacturne grass 774 13 177 357 Tropius grass 1000 20 169 387 Turtwig grass 102 4 64 388 Grotle grass 970 11 141 389 Torterra grass 3100 22 208 406 Budew grass 12 2 68 407 Roserade grass 145 9 204 420 Cherubi grass 33 4 68 421 Cherrim grass 93 5 133 455 Carnivine grass 270 14 164 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 459 Snover grass 505 10 131 460 Abomasnow grass 1355 22 214 465 Tangrowth grass 1286 20 211 470 Leafeon grass 255 10 196 492 Shaymin grass 21 2 64 495 Snivy grass 81 6 28 496 Servine grass 160 8 145 497 Serperior grass 630 33 238 511 Pansage grass 105 6 63 512 Simisage grass 305 11 174 546 Cottonee grass 6 3 56 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 547 Whimsicott grass 66 7 168 548 Petilil grass 66 5 56 549 Lilligant grass 163 11 168 556 Maractus grass 280 10 161 590 Foongus grass 10 2 59 591 Amoonguss grass 105 6 162 597 Ferroseed grass 188 6 61 598 Ferrothorn grass 1100 10 171 640 Virizion grass 2000 20 261 25 Pikachu electric 60 4 82 26 Raichu electric 300 8 122 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 81 Magnemite electric 60 3 89 82 Magneton electric 600 10 161 100 Voltorb electric 104 5 103 101 Electrode electric 666 12 150 125 Electabuzz electric 300 11 156 135 Jolteon electric 245 8 197 145 Zapdos electric 526 16 216 172 Pichu electric 20 3 42 179 Mareep electric 78 6 59 180 Flaaffy electric 133 8 117 181 Ampharos electric 615 14 194 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 239 Elekid electric 235 6 106 243 Raikou electric 1780 19 216 309 Electrike electric 152 6 104 310 Manectric electric 402 15 168 311 Plusle electric 42 4 120 312 Minun electric 42 4 120 403 Shinx electric 95 5 60 404 Luxio electric 305 9 117 405 Luxray electric 420 14 194 417 Pachirisu electric 39 4 120 462 Magnezone electric 1800 12 211 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 466 Electivire electric 1386 18 199 479 Rotom electric 3 3 132 522 Blitzle electric 298 8 59 523 Zebstrika electric 795 16 174 587 Emolga electric 50 4 150 602 Tynamo electric 3 2 55 603 Eelektrik electric 220 12 142 604 Eelektross electric 805 21 232 642 Thundurus electric 610 15 261 63 Abra psychic 195 9 75 64 Kadabra psychic 565 13 145 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 65 Alakazam psychic 480 15 186 96 Drowzee psychic 324 10 102 97 Hypno psychic 756 16 165 122 Mr. Mime psychic 545 13 136 150 Mewtwo psychic 1220 20 220 151 Mew psychic 40 4 64 177 Natu psychic 20 2 73 178 Xatu psychic 150 15 171 196 Espeon psychic 265 9 197 201 Unown psychic 50 5 61 202 Wobbuffet psychic 285 13 177 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 249 Lugia psychic 2160 52 220 251 Celebi psychic 50 6 64 280 Ralts psychic 66 4 70 281 Kirlia psychic 202 8 140 282 Gardevoir psychic 484 16 208 325 Spoink psychic 306 7 89 326 Grumpig psychic 715 9 164 358 Chimecho psychic 10 6 147 360 Wynaut psychic 140 6 44 386 Deoxys psychic 608 17 215 433 Chingling psychic 6 2 74 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 439 Mime Jr. psychic 130 6 78 475 Gallade psychic 520 16 208 480 Uxie psychic 3 3 210 481 Mesprit psychic 3 3 210 482 Azelf psychic 3 3 210 488 Cresselia psychic 856 15 210 494 Victini psychic 40 4 270 517 Munna psychic 233 6 58 518 Musharna psychic 605 11 170 527 Woobat psychic 21 4 63 528 Swoobat psychic 105 9 149 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 561 Sigilyph psychic 140 14 172 574 Gothita psychic 58 4 58 575 Gothorita psychic 180 7 137 576 Gothitelle psychic 440 15 221 577 Solosis psychic 10 3 58 578 Duosion psychic 80 6 130 579 Reuniclus psychic 201 10 221 605 Elgyem psychic 90 5 67 606 Beheeyem psychic 345 10 170 1000 CS365chu psychic 300 8 200 124 Jynx ice 406 14 137 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 144 Articuno ice 554 17 215 220 Swinub ice 65 4 78 221 Piloswine ice 558 11 160 225 Delibird ice 160 9 183 238 Smoochum ice 60 4 87 361 Snorunt ice 168 7 74 362 Glalie ice 2565 15 187 363 Spheal ice 395 8 75 364 Sealeo ice 876 11 128 365 Walrein ice 1506 14 192 378 Regice ice 1750 18 216 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 471 Glaceon ice 259 8 196 473 Mamoswine ice 2910 25 207 478 Froslass ice 266 13 187 582 Vanillite ice 57 4 61 583 Vanillish ice 410 11 138 584 Vanilluxe ice 575 13 241 613 Cubchoo ice 85 5 61 614 Beartic ice 2600 26 170 615 Cryogonal ice 1480 11 170 147 Dratini dragon 33 18 67 148 Dragonair dragon 165 40 144 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 149 Dragonite dragon 2100 22 218 334 Altaria dragon 206 11 188 371 Bagon dragon 421 6 89 372 Shelgon dragon 1105 11 144 373 Salamence dragon 1026 15 218 380 Latias dragon 400 14 211 381 Latios dragon 600 20 211 384 Rayquaza dragon 2065 70 220 443 Gible dragon 205 7 67 444 Gabite dragon 560 14 144 445 Garchomp dragon 950 19 218 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 610 Axew dragon 180 6 64 611 Fraxure dragon 360 10 144 612 Haxorus dragon 1055 18 243 621 Druddigon dragon 1390 16 170 643 Reshiram dragon 3300 32 306 644 Zekrom dragon 3450 29 306 646 Kyurem dragon 3250 30 297 197 Umbreon dark 270 10 197 198 Murkrow dark 21 5 107 215 Sneasel dark 280 9 132 228 Houndour dark 108 6 114 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 229 Houndoom dark 350 14 204 261 Poochyena dark 136 5 55 262 Mightyena dark 370 10 128 302 Sableye dark 110 5 98 359 Absol dark 470 12 174 430 Honchkrow dark 273 9 187 461 Weavile dark 340 11 199 491 Darkrai dark 505 15 210 509 Purrloin dark 101 4 56 510 Liepard dark 375 11 156 559 Scraggy dark 118 6 70 POKEDEXID NAME TYPE WEIGHT HEIGHT EXP ---------- -------------------- -------------------- ---------- ---------- ---------- 560 Scrafty dark 300 11 171 570 Zorua dark 125 7 66 571 Zoroark dark 811 16 179 624 Pawniard dark 102 5 68 625 Bisharp dark 700 16 172 629 Vullaby dark 90 5 74 630 Mandibuzz dark 395 12 179 633 Deino dark 173 8 60 634 Zweilous dark 500 14 147 635 Hydreigon dark 1600 18 270 648 rows selected. SQL> select name, weight/height from poke where pokedexid < 20; NAME WEIGHT/HEIGHT -------------------- ------------- Pidgey 6 Pidgeotto 27.2727273 Pidgeot 26.3333333 Rattata 11.6666667 Caterpie 9.66666667 Metapod 14.1428571 Butterfree 29.0909091 Weedle 10.6666667 Kakuna 16.6666667 Beedrill 29.5 Charmander 14.1666667 NAME WEIGHT/HEIGHT -------------------- ------------- Charmeleon 17.2727273 Charizard 53.2352941 Squirtle 18 Wartortle 22.5 Blastoise 53.4375 Bulbasaur 9.85714286 Ivysaur 13 Venusaur 50 19 rows selected. SQL> select name , weight/height 2 from poke where pokedexid < 20 3 order by weight/height; NAME WEIGHT/HEIGHT -------------------- ------------- Pidgey 6 Caterpie 9.66666667 Bulbasaur 9.85714286 Weedle 10.6666667 Rattata 11.6666667 Ivysaur 13 Metapod 14.1428571 Charmander 14.1666667 Kakuna 16.6666667 Charmeleon 17.2727273 Squirtle 18 NAME WEIGHT/HEIGHT -------------------- ------------- Wartortle 22.5 Pidgeot 26.3333333 Pidgeotto 27.2727273 Butterfree 29.0909091 Beedrill 29.5 Venusaur 50 Charizard 53.2352941 Blastoise 53.4375 19 rows selected. SQL> select name, weight/height AS BODY_INDEX 2 from poke where pokedexid < 20 3 order by BODY_INDEX; NAME BODY_INDEX -------------------- ---------- Pidgey 6 Caterpie 9.66666667 Bulbasaur 9.85714286 Weedle 10.6666667 Rattata 11.6666667 Ivysaur 13 Metapod 14.1428571 Charmander 14.1666667 Kakuna 16.6666667 Charmeleon 17.2727273 Squirtle 18 NAME BODY_INDEX -------------------- ---------- Wartortle 22.5 Pidgeot 26.3333333 Pidgeotto 27.2727273 Butterfree 29.0909091 Beedrill 29.5 Venusaur 50 Charizard 53.2352941 Blastoise 53.4375 19 rows selected. SQL> SQL> select name, weight/height as BODY_INDEX 2 from poke 3 where pokedexid < 20 and BODY_INDEX < 20 4 ; where pokedexid < 20 and BODY_INDEX < 20 * ERROR at line 3: ORA-00904: "BODY_INDEX": invalid identifier SQL> select name as P, weight, height 2 from poke P 3 where P.pokedexId < 20 4 ; P WEIGHT HEIGHT -------------------- ---------- ---------- Pidgey 18 3 Pidgeotto 300 11 Pidgeot 395 15 Rattata 35 3 Caterpie 29 3 Metapod 99 7 Butterfree 320 11 Weedle 32 3 Kakuna 100 6 Beedrill 295 10 Charmander 85 6 P WEIGHT HEIGHT -------------------- ---------- ---------- Charmeleon 190 11 Charizard 905 17 Squirtle 90 5 Wartortle 225 10 Blastoise 855 16 Bulbasaur 69 7 Ivysaur 130 10 Venusaur 1000 20 19 rows selected. SQL> Late UNION Early; SP2-0734: unknown command beginning "Late UNION..." - rest of line ignored. SQL> ( 2 SELECT * from Late) 3 union 4 (select * from early) 5 ; SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- 1 1967 Packers Chiefs 2 1968 Packers Raiders 3 1969 Jets Colts 35 2001 Ravens Giants 36 2002 Patriots Rams 37 2003 Buccaneers Raiders 38 2004 Patriots Panthers 39 2005 Patriots Eagles 40 2006 Steelers Seahawks 41 2007 Colts Bears 42 2008 Giants Patriots SBNO YEAR WINNER LOSER ---------- ---------- -------------------- -------------------- 43 2009 Steelers Cardinals 44 2010 Saints Colts 45 2011 Packers Steelers 46 2012 Giants Patriots 47 2013 Ravens 49ers 16 rows selected. SQL> (SELECT winner 2 FROM Early 3 ) 4 INTERSECT 5 ( SELECT winner 6 FROM late 7 ) 8 ; WINNER -------------------- Packers SQL> SQL> (select winner from late) MINUS (select winner from early); WINNER -------------------- Buccaneers Colts Giants Patriots Ravens Saints Steelers 7 rows selected. SQL> (select winner from late) minus (select loser from early); WINNER -------------------- Buccaneers Giants Packers Patriots Ravens Saints Steelers 7 rows selected. SQL> (select winner AS WON from late) minus (select loser as LOST from early); WON -------------------- Buccaneers Giants Packers Patriots Ravens Saints Steelers 7 rows selected. SQL> (select winner as won from late) intersect (select loser as lost from early); WON -------------------- Colts SQL> (select winner AS WON from late) minus (select loser as LOST from early order by loser); (select winner AS WON from late) minus (select loser as LOST from early order by loser) * ERROR at line 1: ORA-00907: missing right parenthesis SQL> (select winner from late order by winner) union (select winner from early); (select winner from late order by winner) union (select winner from early) * ERROR at line 1: ORA-00907: missing right parenthesis SQL> (select winner from late) union (select winner from early) order by winner; WINNER -------------------- Buccaneers Colts Giants Jets Packers Patriots Ravens Saints Steelers 9 rows selected. SQL> (select winner, loser from late) union (select winner, loser from early) order by winner; WINNER LOSER -------------------- -------------------- Buccaneers Raiders Colts Bears Giants Patriots Jets Colts Packers Chiefs Packers Raiders Packers Steelers Patriots Eagles Patriots Panthers Patriots Rams Ravens 49ers WINNER LOSER -------------------- -------------------- Ravens Giants Saints Colts Steelers Cardinals Steelers Seahawks 15 rows selected. SQL> (select winner, year - 2000 AS Diff from late) union (select winner, year - 2000 from early) 2 order by diff; WINNER DIFF -------------------- ---------- Packers -33 Packers -32 Jets -31 Ravens 1 Patriots 2 Buccaneers 3 Patriots 4 Patriots 5 Steelers 6 Colts 7 Giants 8 WINNER DIFF -------------------- ---------- Steelers 9 Saints 10 Packers 11 Giants 12 Ravens 13 16 rows selected. SQL> (select winner, loser, year from late) union (select winner, loser, year from early) 2 order by 2; WINNER LOSER YEAR -------------------- -------------------- ---------- Ravens 49ers 2013 Colts Bears 2007 Steelers Cardinals 2009 Packers Chiefs 1967 Jets Colts 1969 Saints Colts 2010 Patriots Eagles 2005 Ravens Giants 2001 Patriots Panthers 2004 Giants Patriots 2008 Giants Patriots 2012 WINNER LOSER YEAR -------------------- -------------------- ---------- Buccaneers Raiders 2003 Packers Raiders 1968 Patriots Rams 2002 Steelers Seahawks 2006 Packers Steelers 2011 16 rows selected. SQL> (select winner AS WON from late) minus (select loser as LOST from(select winner AS WON from late) minus (select loser as LOST from 2 ; * ERROR at line 2: ORA-00903: invalid table name SQL> (select winner, loser, year from late) union (select winner, loser, year from early) 2 SQL> order by 3; SP2-0042: unknown command "order by 3" - rest of line ignored. SQL> (select winner, loser, year from late) union (select winner, loser, year from early) 2 order by 3; WINNER LOSER YEAR -------------------- -------------------- ---------- Packers Chiefs 1967 Packers Raiders 1968 Jets Colts 1969 Ravens Giants 2001 Patriots Rams 2002 Buccaneers Raiders 2003 Patriots Panthers 2004 Patriots Eagles 2005 Steelers Seahawks 2006 Colts Bears 2007 Giants Patriots 2008 WINNER LOSER YEAR -------------------- -------------------- ---------- Steelers Cardinals 2009 Saints Colts 2010 Packers Steelers 2011 Giants Patriots 2012 Ravens 49ers 2013 16 rows selected. SQL> (select winner from late) union (select winner from early); WINNER -------------------- Buccaneers Colts Giants Jets Packers Patriots Ravens Saints Steelers 9 rows selected. SQL> select lower(teamname), superbowlwins*superbowlwins, 1, 'Yes' 2 from teams; LOWER(TEAMNAME) SUPERBOWLWINS*SUPERBOWLWINS 1 'YE -------------------- --------------------------- ---------- --- steelers 36 1 Yes cowboys 25 1 Yes patriots 9 1 Yes 49ers 25 1 Yes broncos 4 1 Yes packers 16 1 Yes giants 16 1 Yes redskins 9 1 Yes raiders 9 1 Yes dolphins 4 1 Yes colts 4 1 Yes LOWER(TEAMNAME) SUPERBOWLWINS*SUPERBOWLWINS 1 'YE -------------------- --------------------------- ---------- --- vikings 0 1 Yes bills 0 1 Yes rams 1 1 Yes chiefs 1 1 Yes bears 1 1 Yes ravens 1 1 Yes bengals 0 1 Yes eagles 0 1 Yes jets 1 1 Yes buccaneers 1 1 Yes saints 1 1 Yes LOWER(TEAMNAME) SUPERBOWLWINS*SUPERBOWLWINS 1 'YE -------------------- --------------------------- ---------- --- chargers 0 1 Yes falcons 0 1 Yes titans 0 1 Yes panthers 0 1 Yes seahawks 0 1 Yes cardinals 0 1 Yes browns 0 1 Yes lions 0 1 Yes jaguars 0 1 Yes texans 0 1 Yes 32 rows selected. SQL> (select winner, loser, 'EARLY' from superbowls where year < 1970) union 2 (select winner, loser, 'LATE' from superbowls where year > 2000); WINNER LOSER 'EARL -------------------- -------------------- ----- Buccaneers Raiders LATE Colts Bears LATE Giants Patriots LATE Jets Colts EARLY Packers Chiefs EARLY Packers Raiders EARLY Packers Steelers LATE Patriots Eagles LATE Patriots Panthers LATE Patriots Rams LATE Ravens 49ers LATE WINNER LOSER 'EARL -------------------- -------------------- ----- Ravens Giants LATE Saints Colts LATE Steelers Cardinals LATE Steelers Seahawks LATE 15 rows selected. SQL> select winner, rowid from superbowls; WINNER ROWID -------------------- ------------------ Ravens AADaR1AAEAAA2q2AAA Packers AADaR1AAEAAA2q3AAA Packers AADaR1AAEAAA2q3AAB Jets AADaR1AAEAAA2q3AAC Chiefs AADaR1AAEAAA2q3AAD Colts AADaR1AAEAAA2q3AAE Cowboys AADaR1AAEAAA2q3AAF Dolphins AADaR1AAEAAA2q3AAG Dolphins AADaR1AAEAAA2q3AAH Steelers AADaR1AAEAAA2q3AAI Steelers AADaR1AAEAAA2q3AAJ WINNER ROWID -------------------- ------------------ Raiders AADaR1AAEAAA2q3AAK Cowboys AADaR1AAEAAA2q3AAL Steelers AADaR1AAEAAA2q3AAM Steelers AADaR1AAEAAA2q3AAN Raiders AADaR1AAEAAA2q3AAO 49ers AADaR1AAEAAA2q3AAP Redskins AADaR1AAEAAA2q3AAQ Raiders AADaR1AAEAAA2q3AAR 49ers AADaR1AAEAAA2q3AAS Bears AADaR1AAEAAA2q3AAT Giants AADaR1AAEAAA2q3AAU WINNER ROWID -------------------- ------------------ Redskins AADaR1AAEAAA2q3AAV 49ers AADaR1AAEAAA2q3AAW 49ers AADaR1AAEAAA2q3AAX Giants AADaR1AAEAAA2q3AAY Redskins AADaR1AAEAAA2q3AAZ Cowboys AADaR1AAEAAA2q3AAa Cowboys AADaR1AAEAAA2q3AAb 49ers AADaR1AAEAAA2q3AAc Cowboys AADaR1AAEAAA2q3AAd Packers AADaR1AAEAAA2q3AAe Broncos AADaR1AAEAAA2q3AAf WINNER ROWID -------------------- ------------------ Broncos AADaR1AAEAAA2q3AAg Rams AADaR1AAEAAA2q3AAh Ravens AADaR1AAEAAA2q3AAi Patriots AADaR1AAEAAA2q3AAj Buccaneers AADaR1AAEAAA2q3AAk Patriots AADaR1AAEAAA2q3AAl Patriots AADaR1AAEAAA2q3AAm Steelers AADaR1AAEAAA2q3AAn Colts AADaR1AAEAAA2q3AAo Giants AADaR1AAEAAA2q3AAp Steelers AADaR1AAEAAA2q3AAq WINNER ROWID -------------------- ------------------ Saints AADaR1AAEAAA2q3AAr Packers AADaR1AAEAAA2q3AAs Giants AADaR1AAEAAA2q3AAt 47 rows selected. SQL> select * from superbowls where rowid = 1; select * from superbowls where rowid = 1 * ERROR at line 1: ORA-00932: inconsistent datatypes: expected ROWID got NUMBER SQL> exit