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