Team Ai
Apppublic

luulinh90s/Tabular-LLM-Study-Preference-Ranking

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

Showing the first 1,200 of 1267 lines. Download the file for the rest.