Team Ai
Apppublic

luulinh90s/Tabular-LLM-Study-Debugging

sourceHugging Facemitupdated 2y agoView on Hugging Face
0likes
test-1820.html1182 linesDownload Raw Back to TN
1<html><head>2<style>3body { font-family: Arial, sans-serif; margin: 20px; }4h1 { text-align: center; }5.cot-title { color: blue; }6.pos-title { color: green; }7h2 { color: black; text-align: left; }8h3 { color: black; text-align: left; }9h4 { color: darkslategray; }10table { width: 100%; border-collapse: collapse; margin: 20px 0; }11table, th, td { border: 1px solid #ddd; padding: 8px; }12th { background-color: #f2f2f2; }13tr:nth-child(even) { background-color: #f9f9f9; }14.highlight { background-color: #ffffcc; }15.true { color: green; }16.false { color: red; }17.highlighted-cell { background-color: yellow; cursor: pointer; }18.step-title { background-color: #f1f1f1; color: #444; padding: 10px; margin: 10px 0; font-size: 18px; border-left: 4px solid #888; }19.step { display: block; }20</style>21</head><body>22<hr>23<h3><span>Statement:</span> all but one season is about to have or had an army - navy game in baltimore , md (m&t bank stadium)</h3>24<h3>Input Table: commander - in - chief 's trophy</h3>25<div class="step">26<div class="step">27<div class="step-title">Step 1: Select rows where the 'season' is not 'tbd'.</div>28<div id="step-1" class="content">29<table>30<tr>31<td>season</td>32<td>trophy_winner</td>33<td>air_force___navy_score</td>34<td>air_force___army_score</td>35<td>army___navy_score</td>36</tr>37<tr>38<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1972-01-01</span></td>39<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">army</span></td>40<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">21 - 17</span></td>41<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">17 - 14</span></td>42<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">23 - 15</span></td>43</tr>44<tr>45<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1973-01-01</span></td>46<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">navy</span></td>47<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">42 - 6</span></td>48<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">43 - 10</span></td>49<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">51 - 0</span></td>50</tr>51<tr>52<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1974-01-01</span></td>53<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">shared (navy retained trophy)</span></td>54<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">19 - 16</span></td>55<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">17 - 16</span></td>56<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">19 - 0</span></td>57</tr>58<tr>59<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1975-01-01</span></td>60<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">navy</span></td>61<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">17 - 0</span></td>62<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">33 - 3</span></td>63<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">30 - 6</span></td>64</tr>65<tr>66<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1976-01-01</span></td>67<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">shared (navy retained trophy)</span></td>68<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">13 - 3</span></td>69<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">24 - 7</span></td>70<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">38 - 10</span></td>71</tr>72<tr>73<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1977-01-01</span></td>74<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">army</span></td>75<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">10 - 7</span></td>76<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">31 - 6</span></td>77<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">17 - 14</span></td>78</tr>79<tr>80<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1978-01-01</span></td>81<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">navy</span></td>82<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">37 - 8</span></td>83<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">28 - 14</span></td>84<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">28 - 0</span></td>85</tr>86<tr>87<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1979-01-01</span></td>88<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">navy</span></td>89<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">13 - 9</span></td>90<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">28 - 7</span></td>91<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">31 - 7</span></td>92</tr>93<tr>94<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1980-01-01</span></td>95<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">shared (navy retained trophy)</span></td>96<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">21 - 20</span></td>97<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">47 - 24</span></td>98<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">33 - 6</span></td>99</tr>100<tr>101<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1981-01-01</span></td>102<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">navy</span></td>103<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">30 - 13</span></td>104<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">7 - 3</span></td>105<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">3 - 3</span></td>106</tr>107<tr>108<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1982-01-01</span></td>109<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>110<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">24 - 21</span></td>111<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">27 - 9</span></td>112<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">24 - 7</span></td>113</tr>114<tr>115<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1983-01-01</span></td>116<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>117<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">44 - 17</span></td>118<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">41 - 20</span></td>119<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">42 - 13</span></td>120</tr>121<tr>122<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1984-01-01</span></td>123<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">army</span></td>124<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">29 - 22</span></td>125<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">24 - 12</span></td>126<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">28 - 11</span></td>127</tr>128<tr>129<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1985-01-01</span></td>130<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>131<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">24 - 7</span></td>132<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">45 - 7</span></td>133<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">17 - 7</span></td>134</tr>135<tr>136<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1986-01-01</span></td>137<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">army</span></td>138<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">40 - 6</span></td>139<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">21 - 11</span></td>140<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">27 - 7</span></td>141</tr>142<tr>143<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1987-01-01</span></td>144<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>145<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">23 - 13</span></td>146<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">27 - 10</span></td>147<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">17 - 3</span></td>148</tr>149<tr>150<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1988-01-01</span></td>151<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">army</span></td>152<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">34 - 24</span></td>153<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">28 - 15</span></td>154<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">20 - 15</span></td>155</tr>156<tr>157<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1989-01-01</span></td>158<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>159<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">35 - 7</span></td>160<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">29 - 3</span></td>161<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">19 - 17</span></td>162</tr>163<tr>164<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1990-01-01</span></td>165<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>166<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">24 - 7</span></td>167<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">15 - 3</span></td>168<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">30 - 20</span></td>169</tr>170<tr>171<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1991-01-01</span></td>172<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>173<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">46 - 6</span></td>174<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">25 - 0</span></td>175<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">24 - 3</span></td>176</tr>177<tr>178<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1992-01-01</span></td>179<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>180<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">18 - 16</span></td>181<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">7 - 3</span></td>182<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">25 - 24</span></td>183</tr>184<tr>185<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1993-01-01</span></td>186<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">shared (af retained trophy)</span></td>187<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">28 - 24</span></td>188<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">25 - 6</span></td>189<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">16 - 14</span></td>190</tr>191<tr>192<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1994-01-01</span></td>193<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>194<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">43 - 21</span></td>195<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">10 - 6</span></td>196<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">22 - 20</span></td>197</tr>198<tr>199<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1995-01-01</span></td>200<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>201<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">30 - 20</span></td>202<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">38 - 20</span></td>203<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">14 - 13</span></td>204</tr>205<tr>206<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1996-01-01</span></td>207<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">army</span></td>208<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">20 - 17</span></td>209<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">23 - 7</span></td>210<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">28 - 24</span></td>211</tr>212<tr>213<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1997-01-01</span></td>214<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>215<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">10 - 7</span></td>216<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">24 - 0</span></td>217<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">39 - 7</span></td>218</tr>219<tr>220<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1998-01-01</span></td>221<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>222<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">49 - 7</span></td>223<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">35 - 7</span></td>224<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">34 - 30</span></td>225</tr>226<tr>227<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1999-01-01</span></td>228<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>229<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">19 - 14</span></td>230<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">28 - 0</span></td>231<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">19 - 9</span></td>232</tr>233<tr>234<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">2000-01-01</span></td>235<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>236<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">27 - 13</span></td>237<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">41 - 27</span></td>238<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">30 - 28</span></td>239</tr>240<tr>241<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">2001-01-01</span></td>242<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>243<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">24 - 18</span></td>244<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">34 - 24</span></td>245<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">26 - 17</span></td>246</tr>247<tr>248<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">2002-01-01</span></td>249<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>250<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">48 - 7</span></td>251<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">49 - 30</span></td>252<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">58 - 12</span></td>253</tr>254<tr>255<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">2003-01-01</span></td>256<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">navy</span></td>257<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">28 - 25</span></td>258<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">31 - 3</span></td>259<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">34 - 6</span></td>260</tr>261<tr>262<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">2004-01-01</span></td>263<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">navy</span></td>264<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">24 - 21</span></td>265<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">31 - 22</span></td>266<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">42 - 13</span></td>267</tr>268<tr>269<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">2005-01-01</span></td>270<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">navy</span></td>271<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">27 - 24</span></td>272<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">27 - 24</span></td>273<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">42 - 23</span></td>274</tr>275<tr>276<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">2006-01-01</span></td>277<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">navy</span></td>278<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">24 - 17</span></td>279<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">43 - 7</span></td>280<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">26 - 14</span></td>281</tr>282<tr>283<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">2007-01-01</span></td>284<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">navy</span></td>285<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">31 - 20</span></td>286<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">30 - 10</span></td>287<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">38 - 3</span></td>288</tr>289<tr>290<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">2008-01-01</span></td>291<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">navy</span></td>292<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">33 - 27</span></td>293<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">16 - 7</span></td>294<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">34 - 0</span></td>295</tr>296<tr>297<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">2009-01-01</span></td>298<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">navy</span></td>299<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">16 - 13 (ot)</span></td>300<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">35 - 7</span></td>301<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">17 - 3</span></td>302</tr>303<tr>304<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">2010-01-01</span></td>305<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>306<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">14 - 6</span></td>307<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">42 - 22</span></td>308<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">31 - 17</span></td>309</tr>310<tr>311<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">2011-01-01</span></td>312<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>313<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">35 - 34 (ot)</span></td>314<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">24 - 14</span></td>315<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">27 - 21</span></td>316</tr>317<tr>318<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">2012-01-01</span></td>319<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">navy</span></td>320<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">28 - 21 (ot)</span></td>321<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">41 - 21</span></td>322<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">17 - 13</span></td>323</tr>324<tr>325<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">2014-01-01</span></td>326<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tbd</span></td>327<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">4 oct 2014 at air force</span></td>328<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1 nov 2014 at army</span></td>329<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">13 dec 2014 at baltimore , md (m&t bank stadium)</span></td>330</tr>331<tr>332<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">2016-01-01</span></td>333<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tbd</span></td>334<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tbd</span></td>335<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tbd</span></td>336<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">10 dec 2016 at baltimore , md (m&t bank stadium)</span></td>337</tr>338<tr>339<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">2018-01-01</span></td>340<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tbd</span></td>341<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tbd</span></td>342<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tbd</span></td>343<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">8 dec 2018</span></td>344</tr>345</table>346</div>347<hr>348<div class="step">349<div class="step-title">Step 2: Select rows where the 'trophy_winner' is not 'army' or 'navy'.</div>350<div id="step-0" class="content">351<table>352<tr>353<td>season</td>354<td>trophy_winner</td>355<td>air_force___navy_score</td>356<td>air_force___army_score</td>357<td>army___navy_score</td>358</tr>359<tr>360<td>1972-01-01</td>361<td>army</td>362<td>21 - 17</td>363<td>17 - 14</td>364<td>23 - 15</td>365</tr>366<tr>367<td>1973-01-01</td>368<td>navy</td>369<td>42 - 6</td>370<td>43 - 10</td>371<td>51 - 0</td>372</tr>373<tr>374<td>1974-01-01</td>375<td>shared (navy retained trophy)</td>376<td>19 - 16</td>377<td>17 - 16</td>378<td>19 - 0</td>379</tr>380<tr>381<td>1975-01-01</td>382<td>navy</td>383<td>17 - 0</td>384<td>33 - 3</td>385<td>30 - 6</td>386</tr>387<tr>388<td>1976-01-01</td>389<td>shared (navy retained trophy)</td>390<td>13 - 3</td>391<td>24 - 7</td>392<td>38 - 10</td>393</tr>394<tr>395<td>1977-01-01</td>396<td>army</td>397<td>10 - 7</td>398<td>31 - 6</td>399<td>17 - 14</td>400</tr>401<tr>402<td>1978-01-01</td>403<td>navy</td>404<td>37 - 8</td>405<td>28 - 14</td>406<td>28 - 0</td>407</tr>408<tr>409<td>1979-01-01</td>410<td>navy</td>411<td>13 - 9</td>412<td>28 - 7</td>413<td>31 - 7</td>414</tr>415<tr>416<td>1980-01-01</td>417<td>shared (navy retained trophy)</td>418<td>21 - 20</td>419<td>47 - 24</td>420<td>33 - 6</td>421</tr>422<tr>423<td>1981-01-01</td>424<td>navy</td>425<td>30 - 13</td>426<td>7 - 3</td>427<td>3 - 3</td>428</tr>429<tr>430<td>1982-01-01</td>431<td>air force</td>432<td>24 - 21</td>433<td>27 - 9</td>434<td>24 - 7</td>435</tr>436<tr>437<td>1983-01-01</td>438<td>air force</td>439<td>44 - 17</td>440<td>41 - 20</td>441<td>42 - 13</td>442</tr>443<tr>444<td>1984-01-01</td>445<td>army</td>446<td>29 - 22</td>447<td>24 - 12</td>448<td>28 - 11</td>449</tr>450<tr>451<td>1985-01-01</td>452<td>air force</td>453<td>24 - 7</td>454<td>45 - 7</td>455<td>17 - 7</td>456</tr>457<tr>458<td>1986-01-01</td>459<td>army</td>460<td>40 - 6</td>461<td>21 - 11</td>462<td>27 - 7</td>463</tr>464<tr>465<td>1987-01-01</td>466<td>air force</td>467<td>23 - 13</td>468<td>27 - 10</td>469<td>17 - 3</td>470</tr>471<tr>472<td>1988-01-01</td>473<td>army</td>474<td>34 - 24</td>475<td>28 - 15</td>476<td>20 - 15</td>477</tr>478<tr>479<td>1989-01-01</td>480<td>air force</td>481<td>35 - 7</td>482<td>29 - 3</td>483<td>19 - 17</td>484</tr>485<tr>486<td>1990-01-01</td>487<td>air force</td>488<td>24 - 7</td>489<td>15 - 3</td>490<td>30 - 20</td>491</tr>492<tr>493<td>1991-01-01</td>494<td>air force</td>495<td>46 - 6</td>496<td>25 - 0</td>497<td>24 - 3</td>498</tr>499<tr>500<td>1992-01-01</td>501<td>air force</td>502<td>18 - 16</td>503<td>7 - 3</td>504<td>25 - 24</td>505</tr>506<tr>507<td>1993-01-01</td>508<td>shared (af retained trophy)</td>509<td>28 - 24</td>510<td>25 - 6</td>511<td>16 - 14</td>512</tr>513<tr>514<td>1994-01-01</td>515<td>air force</td>516<td>43 - 21</td>517<td>10 - 6</td>518<td>22 - 20</td>519</tr>520<tr>521<td>1995-01-01</td>522<td>air force</td>523<td>30 - 20</td>524<td>38 - 20</td>525<td>14 - 13</td>526</tr>527<tr>528<td>1996-01-01</td>529<td>army</td>530<td>20 - 17</td>531<td>23 - 7</td>532<td>28 - 24</td>533</tr>534<tr>535<td>1997-01-01</td>536<td>air force</td>537<td>10 - 7</td>538<td>24 - 0</td>539<td>39 - 7</td>540</tr>541<tr>542<td>1998-01-01</td>543<td>air force</td>544<td>49 - 7</td>545<td>35 - 7</td>546<td>34 - 30</td>547</tr>548<tr>549<td>1999-01-01</td>550<td>air force</td>551<td>19 - 14</td>552<td>28 - 0</td>553<td>19 - 9</td>554</tr>555<tr>556<td>2000-01-01</td>557<td>air force</td>558<td>27 - 13</td>559<td>41 - 27</td>560<td>30 - 28</td>561</tr>562<tr>563<td>2001-01-01</td>564<td>air force</td>565<td>24 - 18</td>566<td>34 - 24</td>567<td>26 - 17</td>568</tr>569<tr>570<td>2002-01-01</td>571<td>air force</td>572<td>48 - 7</td>573<td>49 - 30</td>574<td>58 - 12</td>575</tr>576<tr>577<td>2003-01-01</td>578<td>navy</td>579<td>28 - 25</td>580<td>31 - 3</td>581<td>34 - 6</td>582</tr>583<tr>584<td>2004-01-01</td>585<td>navy</td>586<td>24 - 21</td>587<td>31 - 22</td>588<td>42 - 13</td>589</tr>590<tr>591<td>2005-01-01</td>592<td>navy</td>593<td>27 - 24</td>594<td>27 - 24</td>595<td>42 - 23</td>596</tr>597<tr>598<td>2006-01-01</td>599<td>navy</td>600<td>24 - 17</td>601<td>43 - 7</td>602<td>26 - 14</td>603</tr>604<tr>605<td>2007-01-01</td>606<td>navy</td>607<td>31 - 20</td>608<td>30 - 10</td>609<td>38 - 3</td>610</tr>611<tr>612<td>2008-01-01</td>613<td>navy</td>614<td>33 - 27</td>615<td>16 - 7</td>616<td>34 - 0</td>617</tr>618<tr>619<td>2009-01-01</td>620<td>navy</td>621<td>16 - 13 (ot)</td>622<td>35 - 7</td>623<td>17 - 3</td>624</tr>625<tr>626<td>2010-01-01</td>627<td>air force</td>628<td>14 - 6</td>629<td>42 - 22</td>630<td>31 - 17</td>631</tr>632<tr>633<td>2011-01-01</td>634<td>air force</td>635<td>35 - 34 (ot)</td>636<td>24 - 14</td>637<td>27 - 21</td>638</tr>639<tr>640<td>2012-01-01</td>641<td>navy</td>642<td>28 - 21 (ot)</td>643<td>41 - 21</td>644<td>17 - 13</td>645</tr>646<tr>647<td>2014-01-01</td>648<td>tbd</td>649<td>4 oct 2014 at air force</td>650<td>1 nov 2014 at army</td>651<td>13 dec 2014 at baltimore , md (m&t bank stadium)</td>652</tr>653<tr>654<td>2016-01-01</td>655<td>tbd</td>656<td>tbd</td>657<td>tbd</td>658<td>10 dec 2016 at baltimore , md (m&t bank stadium)</td>659</tr>660<tr>661<td>2018-01-01</td>662<td>tbd</td>663<td>tbd</td>664<td>tbd</td>665<td>8 dec 2018</td>666</tr>667</table>668</div>669</div>670<hr>671<div class="step">672<div class="step-title">Step 3: Select rows where the 'trophy_winner' is not 'shared (navy retained trophy)'.</div>673<div id="step-1" class="content">674<table>675<tr>676<td>season</td>677<td>trophy_winner</td>678<td>air_force___navy_score</td>679<td>air_force___army_score</td>680<td>army___navy_score</td>681</tr>682<tr>683<td>1974-01-01</td>684<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">shared (navy retained trophy)</span></td>685<td>19 - 16</td>686<td>17 - 16</td>687<td>19 - 0</td>688</tr>689<tr>690<td>1976-01-01</td>691<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">shared (navy retained trophy)</span></td>692<td>13 - 3</td>693<td>24 - 7</td>694<td>38 - 10</td>695</tr>696<tr>697<td>1980-01-01</td>698<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">shared (navy retained trophy)</span></td>699<td>21 - 20</td>700<td>47 - 24</td>701<td>33 - 6</td>702</tr>703<tr>704<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1982-01-01</span></td>705<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">air force</span></td>706<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">24 - 21</span></td>707<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">27 - 9</span></td>708<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">24 - 7</span></td>709</tr>710<tr>711<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1983-01-01</span></td>712<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">air force</span></td>713<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">44 - 17</span></td>714<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">41 - 20</span></td>715<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">42 - 13</span></td>716</tr>717<tr>718<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1985-01-01</span></td>719<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">air force</span></td>720<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">24 - 7</span></td>721<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">45 - 7</span></td>722<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">17 - 7</span></td>723</tr>724<tr>725<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1987-01-01</span></td>726<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">air force</span></td>727<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">23 - 13</span></td>728<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">27 - 10</span></td>729<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">17 - 3</span></td>730</tr>731<tr>732<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1989-01-01</span></td>733<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">air force</span></td>734<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">35 - 7</span></td>735<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">29 - 3</span></td>736<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">19 - 17</span></td>737</tr>738<tr>739<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1990-01-01</span></td>740<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">air force</span></td>741<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">24 - 7</span></td>742<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">15 - 3</span></td>743<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">30 - 20</span></td>744</tr>745<tr>746<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1991-01-01</span></td>747<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">air force</span></td>748<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">46 - 6</span></td>749<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">25 - 0</span></td>750<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">24 - 3</span></td>751</tr>752<tr>753<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1992-01-01</span></td>754<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">air force</span></td>755<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">18 - 16</span></td>756<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">7 - 3</span></td>757<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">25 - 24</span></td>758</tr>759<tr>760<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1993-01-01</span></td>761<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">shared (af retained trophy)</span></td>762<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">28 - 24</span></td>763<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">25 - 6</span></td>764<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">16 - 14</span></td>765</tr>766<tr>767<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1994-01-01</span></td>768<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">air force</span></td>769<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">43 - 21</span></td>770<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">10 - 6</span></td>771<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">22 - 20</span></td>772</tr>773<tr>774<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1995-01-01</span></td>775<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">air force</span></td>776<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">30 - 20</span></td>777<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">38 - 20</span></td>778<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">14 - 13</span></td>779</tr>780<tr>781<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1997-01-01</span></td>782<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">air force</span></td>783<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">10 - 7</span></td>784<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">24 - 0</span></td>785<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">39 - 7</span></td>786</tr>787<tr>788<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1998-01-01</span></td>789<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">air force</span></td>790<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">49 - 7</span></td>791<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">35 - 7</span></td>792<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">34 - 30</span></td>793</tr>794<tr>795<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1999-01-01</span></td>796<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">air force</span></td>797<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">19 - 14</span></td>798<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">28 - 0</span></td>799<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">19 - 9</span></td>800</tr>801<tr>802<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">2000-01-01</span></td>803<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">air force</span></td>804<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">27 - 13</span></td>805<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">41 - 27</span></td>806<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">30 - 28</span></td>807</tr>808<tr>809<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">2001-01-01</span></td>810<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">air force</span></td>811<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">24 - 18</span></td>812<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">34 - 24</span></td>813<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">26 - 17</span></td>814</tr>815<tr>816<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">2002-01-01</span></td>817<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">air force</span></td>818<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">48 - 7</span></td>819<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">49 - 30</span></td>820<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">58 - 12</span></td>821</tr>822<tr>823<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">2010-01-01</span></td>824<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">air force</span></td>825<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">14 - 6</span></td>826<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">42 - 22</span></td>827<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">31 - 17</span></td>828</tr>829<tr>830<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">2011-01-01</span></td>831<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">air force</span></td>832<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">35 - 34 (ot)</span></td>833<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">24 - 14</span></td>834<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">27 - 21</span></td>835</tr>836<tr>837<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">2014-01-01</span></td>838<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">tbd</span></td>839<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">4 oct 2014 at air force</span></td>840<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1 nov 2014 at army</span></td>841<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">13 dec 2014 at baltimore , md (m&t bank stadium)</span></td>842</tr>843<tr>844<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">2016-01-01</span></td>845<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">tbd</span></td>846<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tbd</span></td>847<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tbd</span></td>848<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">10 dec 2016 at baltimore , md (m&t bank stadium)</span></td>849</tr>850<tr>851<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">2018-01-01</span></td>852<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">tbd</span></td>853<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tbd</span></td>854<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tbd</span></td>855<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">8 dec 2018</span></td>856</tr>857</table>858</div>859</div>860<hr>861<div class="step">862<div class="step-title">Step 4: Select rows where the 'trophy_winner' is not 'air force'.</div>863<div id="step-2" class="content">864<table>865<tr>866<td>season</td>867<td>trophy_winner</td>868<td>air_force___navy_score</td>869<td>air_force___army_score</td>870<td>army___navy_score</td>871</tr>872<tr>873<td>1982-01-01</td>874<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>875<td>24 - 21</td>876<td>27 - 9</td>877<td>24 - 7</td>878</tr>879<tr>880<td>1983-01-01</td>881<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>882<td>44 - 17</td>883<td>41 - 20</td>884<td>42 - 13</td>885</tr>886<tr>887<td>1985-01-01</td>888<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>889<td>24 - 7</td>890<td>45 - 7</td>891<td>17 - 7</td>892</tr>893<tr>894<td>1987-01-01</td>895<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>896<td>23 - 13</td>897<td>27 - 10</td>898<td>17 - 3</td>899</tr>900<tr>901<td>1989-01-01</td>902<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>903<td>35 - 7</td>904<td>29 - 3</td>905<td>19 - 17</td>906</tr>907<tr>908<td>1990-01-01</td>909<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>910<td>24 - 7</td>911<td>15 - 3</td>912<td>30 - 20</td>913</tr>914<tr>915<td>1991-01-01</td>916<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>917<td>46 - 6</td>918<td>25 - 0</td>919<td>24 - 3</td>920</tr>921<tr>922<td>1992-01-01</td>923<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>924<td>18 - 16</td>925<td>7 - 3</td>926<td>25 - 24</td>927</tr>928<tr>929<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1993-01-01</span></td>930<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">shared (af retained trophy)</span></td>931<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">28 - 24</span></td>932<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">25 - 6</span></td>933<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">16 - 14</span></td>934</tr>935<tr>936<td>1994-01-01</td>937<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>938<td>43 - 21</td>939<td>10 - 6</td>940<td>22 - 20</td>941</tr>942<tr>943<td>1995-01-01</td>944<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>945<td>30 - 20</td>946<td>38 - 20</td>947<td>14 - 13</td>948</tr>949<tr>950<td>1997-01-01</td>951<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>952<td>10 - 7</td>953<td>24 - 0</td>954<td>39 - 7</td>955</tr>956<tr>957<td>1998-01-01</td>958<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>959<td>49 - 7</td>960<td>35 - 7</td>961<td>34 - 30</td>962</tr>963<tr>964<td>1999-01-01</td>965<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>966<td>19 - 14</td>967<td>28 - 0</td>968<td>19 - 9</td>969</tr>970<tr>971<td>2000-01-01</td>972<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>973<td>27 - 13</td>974<td>41 - 27</td>975<td>30 - 28</td>976</tr>977<tr>978<td>2001-01-01</td>979<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>980<td>24 - 18</td>981<td>34 - 24</td>982<td>26 - 17</td>983</tr>984<tr>985<td>2002-01-01</td>986<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>987<td>48 - 7</td>988<td>49 - 30</td>989<td>58 - 12</td>990</tr>991<tr>992<td>2010-01-01</td>993<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>994<td>14 - 6</td>995<td>42 - 22</td>996<td>31 - 17</td>997</tr>998<tr>999<td>2011-01-01</td>1000<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">air force</span></td>1001<td>35 - 34 (ot)</td>1002<td>24 - 14</td>1003<td>27 - 21</td>1004</tr>1005<tr>1006<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">2014-01-01</span></td>1007<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">tbd</span></td>1008<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">4 oct 2014 at air force</span></td>1009<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1 nov 2014 at army</span></td>1010<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">13 dec 2014 at baltimore , md (m&t bank stadium)</span></td>1011</tr>1012<tr>1013<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">2016-01-01</span></td>1014<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">tbd</span></td>1015<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tbd</span></td>1016<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tbd</span></td>1017<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">10 dec 2016 at baltimore , md (m&t bank stadium)</span></td>1018</tr>1019<tr>1020<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">2018-01-01</span></td>1021<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">tbd</span></td>1022<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tbd</span></td>1023<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tbd</span></td>1024<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">8 dec 2018</span></td>1025</tr>1026</table>1027</div>1028</div>1029<hr>1030<div class="step">1031<div class="step-title">Step 5: Select rows where the 'trophy_winner' is not 'shared (af retained trophy)'.</div>1032<div id="step-3" class="content">1033<table>1034<tr>1035<td>season</td>1036<td>trophy_winner</td>1037<td>air_force___navy_score</td>1038<td>air_force___army_score</td>1039<td>army___navy_score</td>1040</tr>1041<tr>1042<td>1993-01-01</td>1043<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">shared (af retained trophy)</span></td>1044<td>28 - 24</td>1045<td>25 - 6</td>1046<td>16 - 14</td>1047</tr>1048<tr>1049<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">2014-01-01</span></td>1050<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">tbd</span></td>1051<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">4 oct 2014 at air force</span></td>1052<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1 nov 2014 at army</span></td>1053<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">13 dec 2014 at baltimore , md (m&t bank stadium)</span></td>1054</tr>1055<tr>1056<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">2016-01-01</span></td>1057<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">tbd</span></td>1058<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tbd</span></td>1059<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tbd</span></td>1060<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">10 dec 2016 at baltimore , md (m&t bank stadium)</span></td>1061</tr>1062<tr>1063<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">2018-01-01</span></td>1064<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">tbd</span></td>1065<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tbd</span></td>1066<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tbd</span></td>1067<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">8 dec 2018</span></td>1068</tr>1069</table>1070</div>1071</div>1072<hr>1073<div class="step">1074<div class="step-title">Step 6: Select rows where the 'trophy_winner' is not 'tbd'.</div>1075<div id="step-4" class="content">1076<table>1077<tr>1078<td>season</td>1079<td>trophy_winner</td>1080<td>air_force___navy_score</td>1081<td>air_force___army_score</td>1082<td>army___navy_score</td>1083</tr>1084<tr>1085<td>2014-01-01</td>1086<td>tbd</td>1087<td>4 oct 2014 at air force</td>1088<td>1 nov 2014 at army</td>1089<td>13 dec 2014 at baltimore , md (m&t bank stadium)</td>1090</tr>1091<tr>1092<td>2016-01-01</td>1093<td>tbd</td>1094<td>tbd</td>1095<td>tbd</td>1096<td>10 dec 2016 at baltimore , md (m&t bank stadium)</td>1097</tr>1098<tr>1099<td>2018-01-01</td>1100<td>tbd</td>1101<td>tbd</td>1102<td>tbd</td>1103<td>8 dec 2018</td>1104</tr>1105</table>1106</div>1107</div>1108<hr>1109<div class="step">1110<div class="step-title">Step 7: Select rows where the 'air_force___navy_score' is not 'tbd'.</div>1111<div id="step-5" class="content">1112<table>1113<tr>1114<td>season</td>1115<td>trophy_winner</td>1116<td>air_force___navy_score</td>1117<td>air_force___army_score</td>1118<td>army___navy_score</td>1119</tr>1120</table>1121</div>1122</div>1123<hr>1124<div class="step">1125<div class="step-title">Step 8: Select rows where the 'air_force___army_score' is not 'tbd'.</div>1126<div id="step-6" class="content">1127<table>1128<tr>1129<td>season</td>1130<td>trophy_winner</td>1131<td>air_force___navy_score</td>1132<td>air_force___army_score</td>1133<td>army___navy_score</td>1134</tr>1135</table>1136</div>1137</div>1138<hr>1139<div class="step">1140<div class="step-title">Step 9: Select rows where the 'army___navy_score' is not 'tbd'.</div>1141<div id="step-7" class="content">1142<table>1143<tr>1144<td>season</td>1145<td>trophy_winner</td>1146<td>air_force___navy_score</td>1147<td>air_force___army_score</td>1148<td>army___navy_score</td>1149</tr>1150</table>1151</div>1152</div>1153<hr>1154<div class="step">1155<div class="step-title">Step 10: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.</div>1156<div id="step-8" class="content">1157<table>1158<tr>1159<td>season</td>1160<td>trophy_winner</td>1161<td>air_force___navy_score</td>1162<td>air_force___army_score</td>1163<td>army___navy_score</td>1164</tr>1165</table>1166</div>1167</div>1168<hr>1169<table>1170<tr>1171<td>verification_result</td>1172</tr>1173<tr>1174<td>FALSE</td>1175</tr>1176</table>1177</div>1178</div>1179<hr>1180<h3>Prediction:</span> FALSE</h3>1181</body></html>1182