Team Ai
Apppublic

luulinh90s/Tabular-LLM-Study-Preference-Ranking

sourceHugging Facemitupdated 2y agoView on Hugging Face
0likes
test-660.html779 linesDownload Raw Back to TN
1<html><head>2<style>3body { font-family: Arial, sans-serif; margin: 20px; }4h1 { text-align: center; }5.cot-title { color: blue; }6.pos-title { color: green; }7h2 { color: black; text-align: left; }8h3 { color: black; text-align: left; }9h4 { color: darkslategray; }10table { width: 100%; border-collapse: collapse; margin: 20px 0; }11table, th, td { border: 1px solid #ddd; padding: 8px; }12th { background-color: #f2f2f2; }13tr:nth-child(even) { background-color: #f9f9f9; }14.highlight { background-color: #ffffcc; }15.true { color: green; }16.false { color: red; }17.highlighted-cell { background-color: yellow; cursor: pointer; }18.step-title { background-color: #f1f1f1; color: #444; padding: 10px; margin: 10px 0; font-size: 18px; border-left: 4px solid #888; }19.step { display: block; }20</style>21</head><body>22<hr>23<h3><span>Statement:</span> 217 is the lowest 1st lbsc number with a lbsc name of granville</h3>24<h3>Input Table: list of lb&scr b1 class locomotives</h3>25<div class="step">26<div class="step">27<div class="step-title">Step 1: Order the table by 'c_1st_lbsc_no' in ascending order.</div>28<div id="step-1" class="content">29<table>30<tr>31<td>c_1st_lbsc_no</td>32<td>lbsc_name</td>33<td>built</td>34<td>c_2nd_lbsc_no</td>35<td>c_1st_sr_no</td>36<td>c_2ns_sr_no</td>37<td>withdrawn</td>38</tr>39<tr>40<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">172</span></td>41<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">littlehampton</span></td>42<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1891-01-01</span></td>43<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>44<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">b172</span></td>45<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">2172</span></td>46<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1933</span></td>47</tr>48<tr>49<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">173</span></td>50<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">cottesloe</span></td>51<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1891-01-01</span></td>52<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>53<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">b173</span></td>54<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>55<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1926</span></td>56</tr>57<tr>58<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">174</span></td>59<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">fratton</span></td>60<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1890-01-01</span></td>61<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>62<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">b174</span></td>63<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>64<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1926</span></td>65</tr>66<tr>67<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">175</span></td>68<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">hayling</span></td>69<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1890-01-01</span></td>70<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>71<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>72<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>73<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1926</span></td>74</tr>75<tr>76<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">176</span></td>77<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">pevensey</span></td>78<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1890-01-01</span></td>79<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>80<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">b176</span></td>81<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>82<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1929</span></td>83</tr>84<tr>85<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">177</span></td>86<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">southsea</span></td>87<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1890-01-01</span></td>88<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>89<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">b177</span></td>90<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>91<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1926</span></td>92</tr>93<tr>94<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">178</span></td>95<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">leatherhead</span></td>96<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1890-01-01</span></td>97<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>98<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>99<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>100<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1912</span></td>101</tr>102<tr>103<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">179</span></td>104<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">sandown</span></td>105<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1890-01-01</span></td>106<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>107<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">b179</span></td>108<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>109<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1929</span></td>110</tr>111<tr>112<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">180</span></td>113<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">arundel</span></td>114<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1890-01-01</span></td>115<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>116<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">b180</span></td>117<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>118<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1925</span></td>119</tr>120<tr>121<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">181</span></td>122<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">croydon</span></td>123<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1890-01-01</span></td>124<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>125<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">b181</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;">1929</span></td>128</tr>129<tr>130<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">182</span></td>131<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">hastings</span></td>132<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1889-01-01</span></td>133<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>134<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>135<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>136<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1910</span></td>137</tr>138<tr>139<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">183</span></td>140<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">eastbourne</span></td>141<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1889-01-01</span></td>142<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>143<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>144<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>145<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1929</span></td>146</tr>147<tr>148<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">184</span></td>149<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">carew d gilbert</span></td>150<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1889-01-01</span></td>151<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>152<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">b184</span></td>153<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>154<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1930</span></td>155</tr>156<tr>157<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">185</span></td>158<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">george a wallis</span></td>159<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1889-01-01</span></td>160<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>161<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>162<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>163<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1923</span></td>164</tr>165<tr>166<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">186</span></td>167<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">de la warr</span></td>168<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1889-01-01</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;">-</span></td>172<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1911</span></td>173</tr>174<tr>175<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">187</span></td>176<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">philip rose</span></td>177<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1889-01-01</span></td>178<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>179<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">b187</span></td>180<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>181<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1930</span></td>182</tr>183<tr>184<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">188</span></td>185<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">allen sarle</span></td>186<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1889-01-01</span></td>187<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>188<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">b188</span></td>189<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>190<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1925</span></td>191</tr>192<tr>193<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">189</span></td>194<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">edward blount</span></td>195<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1889-01-01</span></td>196<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>197<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>198<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>199<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1912</span></td>200</tr>201<tr>202<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">190</span></td>203<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">arthur otway</span></td>204<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1888-01-01</span></td>205<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>206<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">b190</span></td>207<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>208<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1930</span></td>209</tr>210<tr>211<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">191</span></td>212<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">gordon - lennox</span></td>213<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1888-01-01</span></td>214<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>215<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">b191</span></td>216<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>217<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1929</span></td>218</tr>219<tr>220<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">192</span></td>221<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">jacomb - hood</span></td>222<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1888-01-01</span></td>223<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>224<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>225<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>226<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1927</span></td>227</tr>228<tr>229<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">193</span></td>230<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">fremantle</span></td>231<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1888-01-01</span></td>232<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>233<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">b193</span></td>234<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>235<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1930</span></td>236</tr>237<tr>238<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">194</span></td>239<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">bickersteth</span></td>240<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1888-01-01</span></td>241<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>242<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">b194</span></td>243<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">2194</span></td>244<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1931</span></td>245</tr>246<tr>247<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">195</span></td>248<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">cardew</span></td>249<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1888-01-01</span></td>250<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>251<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>252<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>253<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1912</span></td>254</tr>255<tr>256<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">196</span></td>257<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">ralph l lopes</span></td>258<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1888-01-01</span></td>259<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>260<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>261<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>262<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1912</span></td>263</tr>264<tr>265<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">197</span></td>266<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">jonas levy</span></td>267<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1888-01-01</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;">b197</span></td>270<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">2197</span></td>271<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1932</span></td>272</tr>273<tr>274<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">198</span></td>275<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">sheffield</span></td>276<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1887-01-01</span></td>277<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>278<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">b198</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;">1930</span></td>281</tr>282<tr>283<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">199</span></td>284<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">samuel laing</span></td>285<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1887-01-01</span></td>286<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>287<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>288<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>289<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1925</span></td>290</tr>291<tr>292<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">200</span></td>293<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">beresford</span></td>294<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1887-01-01</span></td>295<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>296<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">b200</span></td>297<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>298<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1929</span></td>299</tr>300<tr>301<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">214</span></td>302<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">gladstone</span></td>303<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1882-01-01</span></td>304<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">618</span></td>305<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">b214</span></td>306<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>307<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1927</span></td>308</tr>309<tr>310<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">215</span></td>311<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">salisbury</span></td>312<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1883-01-01</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;">-</span></td>315<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>316<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1910</span></td>317</tr>318<tr>319<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">216</span></td>320<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">granville</span></td>321<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1883-01-01</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;">-</span></td>324<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>325<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1911</span></td>326</tr>327<tr>328<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">217</span></td>329<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">northcote</span></td>330<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1883-01-01</span></td>331<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">620</span></td>332<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>333<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>334<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1927</span></td>335</tr>336<tr>337<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">218</span></td>338<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">beaconsfield</span></td>339<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1885-01-01</span></td>340<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>341<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>342<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>343<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1913</span></td>344</tr>345<tr>346<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">219</span></td>347<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">cleveland</span></td>348<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1885-01-01</span></td>349<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">619</span></td>350<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">b619</span></td>351<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>352<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1928</span></td>353</tr>354<tr>355<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">220</span></td>356<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">hampden</span></td>357<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1887-01-01</span></td>358<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>359<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>360<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>361<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1911</span></td>362</tr>363</table>364</div>365<hr>366<div class="step">367<div class="step-title">Step 2: Select row number 1.</div>368<div id="step-0" class="content">369<table>370<tr>371<td>c_1st_lbsc_no</td>372<td>lbsc_name</td>373<td>built</td>374<td>c_2nd_lbsc_no</td>375<td>c_1st_sr_no</td>376<td>c_2ns_sr_no</td>377<td>withdrawn</td>378</tr>379<tr>380<td>172</td>381<td>littlehampton</td>382<td>1891-01-01</td>383<td>-</td>384<td>b172</td>385<td>2172</td>386<td>1933</td>387</tr>388<tr>389<td>173</td>390<td>cottesloe</td>391<td>1891-01-01</td>392<td>-</td>393<td>b173</td>394<td>-</td>395<td>1926</td>396</tr>397<tr>398<td>174</td>399<td>fratton</td>400<td>1890-01-01</td>401<td>-</td>402<td>b174</td>403<td>-</td>404<td>1926</td>405</tr>406<tr>407<td>175</td>408<td>hayling</td>409<td>1890-01-01</td>410<td>-</td>411<td>-</td>412<td>-</td>413<td>1926</td>414</tr>415<tr>416<td>176</td>417<td>pevensey</td>418<td>1890-01-01</td>419<td>-</td>420<td>b176</td>421<td>-</td>422<td>1929</td>423</tr>424<tr>425<td>177</td>426<td>southsea</td>427<td>1890-01-01</td>428<td>-</td>429<td>b177</td>430<td>-</td>431<td>1926</td>432</tr>433<tr>434<td>178</td>435<td>leatherhead</td>436<td>1890-01-01</td>437<td>-</td>438<td>-</td>439<td>-</td>440<td>1912</td>441</tr>442<tr>443<td>179</td>444<td>sandown</td>445<td>1890-01-01</td>446<td>-</td>447<td>b179</td>448<td>-</td>449<td>1929</td>450</tr>451<tr>452<td>180</td>453<td>arundel</td>454<td>1890-01-01</td>455<td>-</td>456<td>b180</td>457<td>-</td>458<td>1925</td>459</tr>460<tr>461<td>181</td>462<td>croydon</td>463<td>1890-01-01</td>464<td>-</td>465<td>b181</td>466<td>-</td>467<td>1929</td>468</tr>469<tr>470<td>182</td>471<td>hastings</td>472<td>1889-01-01</td>473<td>-</td>474<td>-</td>475<td>-</td>476<td>1910</td>477</tr>478<tr>479<td>183</td>480<td>eastbourne</td>481<td>1889-01-01</td>482<td>-</td>483<td>-</td>484<td>-</td>485<td>1929</td>486</tr>487<tr>488<td>184</td>489<td>carew d gilbert</td>490<td>1889-01-01</td>491<td>-</td>492<td>b184</td>493<td>-</td>494<td>1930</td>495</tr>496<tr>497<td>185</td>498<td>george a wallis</td>499<td>1889-01-01</td>500<td>-</td>501<td>-</td>502<td>-</td>503<td>1923</td>504</tr>505<tr>506<td>186</td>507<td>de la warr</td>508<td>1889-01-01</td>509<td>-</td>510<td>-</td>511<td>-</td>512<td>1911</td>513</tr>514<tr>515<td>187</td>516<td>philip rose</td>517<td>1889-01-01</td>518<td>-</td>519<td>b187</td>520<td>-</td>521<td>1930</td>522</tr>523<tr>524<td>188</td>525<td>allen sarle</td>526<td>1889-01-01</td>527<td>-</td>528<td>b188</td>529<td>-</td>530<td>1925</td>531</tr>532<tr>533<td>189</td>534<td>edward blount</td>535<td>1889-01-01</td>536<td>-</td>537<td>-</td>538<td>-</td>539<td>1912</td>540</tr>541<tr>542<td>190</td>543<td>arthur otway</td>544<td>1888-01-01</td>545<td>-</td>546<td>b190</td>547<td>-</td>548<td>1930</td>549</tr>550<tr>551<td>191</td>552<td>gordon - lennox</td>553<td>1888-01-01</td>554<td>-</td>555<td>b191</td>556<td>-</td>557<td>1929</td>558</tr>559<tr>560<td>192</td>561<td>jacomb - hood</td>562<td>1888-01-01</td>563<td>-</td>564<td>-</td>565<td>-</td>566<td>1927</td>567</tr>568<tr>569<td>193</td>570<td>fremantle</td>571<td>1888-01-01</td>572<td>-</td>573<td>b193</td>574<td>-</td>575<td>1930</td>576</tr>577<tr>578<td>194</td>579<td>bickersteth</td>580<td>1888-01-01</td>581<td>-</td>582<td>b194</td>583<td>2194</td>584<td>1931</td>585</tr>586<tr>587<td>195</td>588<td>cardew</td>589<td>1888-01-01</td>590<td>-</td>591<td>-</td>592<td>-</td>593<td>1912</td>594</tr>595<tr>596<td>196</td>597<td>ralph l lopes</td>598<td>1888-01-01</td>599<td>-</td>600<td>-</td>601<td>-</td>602<td>1912</td>603</tr>604<tr>605<td>197</td>606<td>jonas levy</td>607<td>1888-01-01</td>608<td>-</td>609<td>b197</td>610<td>2197</td>611<td>1932</td>612</tr>613<tr>614<td>198</td>615<td>sheffield</td>616<td>1887-01-01</td>617<td>-</td>618<td>b198</td>619<td>-</td>620<td>1930</td>621</tr>622<tr>623<td>199</td>624<td>samuel laing</td>625<td>1887-01-01</td>626<td>-</td>627<td>-</td>628<td>-</td>629<td>1925</td>630</tr>631<tr>632<td>200</td>633<td>beresford</td>634<td>1887-01-01</td>635<td>-</td>636<td>b200</td>637<td>-</td>638<td>1929</td>639</tr>640<tr>641<td>214</td>642<td>gladstone</td>643<td>1882-01-01</td>644<td>618</td>645<td>b214</td>646<td>-</td>647<td>1927</td>648</tr>649<tr>650<td>215</td>651<td>salisbury</td>652<td>1883-01-01</td>653<td>-</td>654<td>-</td>655<td>-</td>656<td>1910</td>657</tr>658<tr>659<td>216</td>660<td>granville</td>661<td>1883-01-01</td>662<td>-</td>663<td>-</td>664<td>-</td>665<td>1911</td>666</tr>667<tr>668<td>217</td>669<td>northcote</td>670<td>1883-01-01</td>671<td>620</td>672<td>-</td>673<td>-</td>674<td>1927</td>675</tr>676<tr>677<td>218</td>678<td>beaconsfield</td>679<td>1885-01-01</td>680<td>-</td>681<td>-</td>682<td>-</td>683<td>1913</td>684</tr>685<tr>686<td>219</td>687<td>cleveland</td>688<td>1885-01-01</td>689<td>619</td>690<td>b619</td>691<td>-</td>692<td>1928</td>693</tr>694<tr>695<td>220</td>696<td>hampden</td>697<td>1887-01-01</td>698<td>-</td>699<td>-</td>700<td>-</td>701<td>1911</td>702</tr>703</table>704</div>705</div>706<hr>707<div class="step">708<div class="step-title">Step 3: Select rows where 'c_1st_lbsc_no' is 217.</div>709<div id="step-1" class="content">710<table>711<tr>712<td>c_1st_lbsc_no</td>713<td>lbsc_name</td>714<td>built</td>715<td>c_2nd_lbsc_no</td>716<td>c_1st_sr_no</td>717<td>c_2ns_sr_no</td>718<td>withdrawn</td>719</tr>720<tr>721<td>172</td>722<td>littlehampton</td>723<td>1891-01-01</td>724<td>-</td>725<td>b172</td>726<td>2172</td>727<td>1933</td>728</tr>729</table>730</div>731</div>732<hr>733<div class="step">734<div class="step-title">Step 4: Select rows where 'lbsc_name' is 'granville'.</div>735<div id="step-2" class="content">736<table>737<tr>738<td>c_1st_lbsc_no</td>739<td>lbsc_name</td>740<td>built</td>741<td>c_2nd_lbsc_no</td>742<td>c_1st_sr_no</td>743<td>c_2ns_sr_no</td>744<td>withdrawn</td>745</tr>746</table>747</div>748</div>749<hr>750<div class="step">751<div class="step-title">Step 5: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.</div>752<div id="step-3" class="content">753<table>754<tr>755<td>c_1st_lbsc_no</td>756<td>lbsc_name</td>757<td>built</td>758<td>c_2nd_lbsc_no</td>759<td>c_1st_sr_no</td>760<td>c_2ns_sr_no</td>761<td>withdrawn</td>762</tr>763</table>764</div>765</div>766<hr>767<table>768<tr>769<td>verification_result</td>770</tr>771<tr>772<td>FALSE</td>773</tr>774</table>775</div>776</div>777<hr>778</body></html>779