Step 2: f_select_column(season, army - navy score)
season |
trophy winner |
air force - navy score |
air force - army score |
army - navy score |
1972 |
army |
21 - 17 |
17 - 14 |
23 - 15 |
1973 |
navy |
42 - 6 |
43 - 10 |
51 - 0 |
1974 |
shared (navy retained trophy) |
19 - 16 |
17 - 16 |
19 - 0 |
1975 |
navy |
17 - 0 |
33 - 3 |
30 - 6 |
1976 |
shared (navy retained trophy) |
13 - 3 |
24 - 7 |
38 - 10 |
1977 |
army |
10 - 7 |
31 - 6 |
17 - 14 |
1978 |
navy |
37 - 8 |
28 - 14 |
28 - 0 |
1979 |
navy |
13 - 9 |
28 - 7 |
31 - 7 |
1980 |
shared (navy retained trophy) |
21 - 20 |
47 - 24 |
33 - 6 |
1981 |
navy |
30 - 13 |
7 - 3 |
3 - 3 |
1982 |
air force |
24 - 21 |
27 - 9 |
24 - 7 |
1983 |
air force |
44 - 17 |
41 - 20 |
42 - 13 |
1984 |
army |
29 - 22 |
24 - 12 |
28 - 11 |
1985 |
air force |
24 - 7 |
45 - 7 |
17 - 7 |
1986 |
army |
40 - 6 |
21 - 11 |
27 - 7 |
1987 |
air force |
23 - 13 |
27 - 10 |
17 - 3 |
1988 |
army |
34 - 24 |
28 - 15 |
20 - 15 |
1989 |
air force |
35 - 7 |
29 - 3 |
19 - 17 |
1990 |
air force |
24 - 7 |
15 - 3 |
30 - 20 |
1991 |
air force |
46 - 6 |
25 - 0 |
24 - 3 |
1992 |
air force |
18 - 16 |
7 - 3 |
25 - 24 |
1993 |
shared (af retained trophy) |
28 - 24 |
25 - 6 |
16 - 14 |
1994 |
air force |
43 - 21 |
10 - 6 |
22 - 20 |
1995 |
air force |
30 - 20 |
38 - 20 |
14 - 13 |
1996 |
army |
20 - 17 |
23 - 7 |
28 - 24 |
1997 |
air force |
10 - 7 |
24 - 0 |
39 - 7 |
1998 |
air force |
49 - 7 |
35 - 7 |
34 - 30 |
1999 |
air force |
19 - 14 |
28 - 0 |
19 - 9 |
2000 |
air force |
27 - 13 |
41 - 27 |
30 - 28 |
2001 |
air force |
24 - 18 |
34 - 24 |
26 - 17 |
2002 |
air force |
48 - 7 |
49 - 30 |
58 - 12 |
2003 |
navy |
28 - 25 |
31 - 3 |
34 - 6 |
2004 |
navy |
24 - 21 |
31 - 22 |
42 - 13 |
2005 |
navy |
27 - 24 |
27 - 24 |
42 - 23 |
2006 |
navy |
24 - 17 |
43 - 7 |
26 - 14 |
2007 |
navy |
31 - 20 |
30 - 10 |
38 - 3 |
2008 |
navy |
33 - 27 |
16 - 7 |
34 - 0 |
2009 |
navy |
16 - 13 (ot) |
35 - 7 |
17 - 3 |
2010 |
air force |
14 - 6 |
42 - 22 |
31 - 17 |
2011 |
air force |
35 - 34 (ot) |
24 - 14 |
27 - 21 |
2012 |
navy |
28 - 21 (ot) |
41 - 21 |
17 - 13 |
2014 |
tbd |
4 oct 2014 at air force |
1 nov 2014 at army |
13 dec 2014 at baltimore , md (m&t bank stadium) |
2016 |
tbd |
tbd |
tbd |
10 dec 2016 at baltimore , md (m&t bank stadium) |
2018 |
tbd |
tbd |
tbd |
8 dec 2018 |