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