Step 1: f_select_row(row 1, row 6, row 7, row 8, row 10, row 11, row 14, row 15, row 17, row 18, row 19, row 20, row 21, row 22, row 23, row 25, row 26, row 27, row 28, row 29, row 30, row 38, row 39, row 40)
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 |
Step 2: f_select_column(season, air force - navy score)
season |
trophy winner |
air force - navy score |
air force - army score |
army - navy score |
1973 |
navy |
42 - 6 |
43 - 10 |
51 - 0 |
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 |
1982 |
air force |
24 - 21 |
27 - 9 |
24 - 7 |
1983 |
air force |
44 - 17 |
41 - 20 |
42 - 13 |
1986 |
army |
40 - 6 |
21 - 11 |
27 - 7 |
1987 |
air force |
23 - 13 |
27 - 10 |
17 - 3 |
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 |
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 |
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 |
Step 3: simple_query()
season |
air force - navy score |
1973 |
42 - 6 |
1978 |
37 - 8 |
1979 |
13 - 9 |
1980 |
21 - 20 |
1982 |
24 - 21 |
1983 |
44 - 17 |
1986 |
40 - 6 |
1987 |
23 - 13 |
1989 |
35 - 7 |
1990 |
24 - 7 |
1991 |
46 - 6 |
1992 |
18 - 16 |
1993 |
28 - 24 |
1994 |
43 - 21 |
1995 |
30 - 20 |
1997 |
10 - 7 |
1998 |
49 - 7 |
1999 |
19 - 14 |
2000 |
27 - 13 |
2001 |
24 - 18 |
2002 |
48 - 7 |
2010 |
14 - 6 |
2011 |
35 - 34 (ot) |
2012 |
28 - 21 (ot) |
Prompting LLM for the final answer... >>>