luulinh90s/Tabular-LLM-Study-Preference-Ranking

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<h1 class="pos-title">Plan-of-SQLs (Ours)</h1>23<hr>24<h3><span>Statement:</span> mcville has goose river bridge which is currently under construction due to structural issues</h3>25<h3>Ground-truth:</span> FALSE</h3>26<h3>Input Table: list of bridges on the national register of historic places in north dakota</h3>27<div class="step">28<div class="step">29<div class="step-title">Step 1: Select rows where 'location' is 'mcville'.</div>30<div id="step-1" class="content">31<table>32<tr>33<td>name</td>34<td>listed</td>35<td>location</td>36<td>county</td>37<td>type</td>38</tr>39<tr>40<td>beaver creek bridge</td>41<td>1997-02-27</td>42<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">finley</span></td>43<td>steele</td>44<td>pratt through truss</td>45</tr>46<tr>47<td>caledonia bridge</td>48<td>1997-02-27</td>49<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">caledonia</span></td>50<td>traill</td>51<td>pratt through truss</td>52</tr>53<tr>54<td>cedar creek bridge</td>55<td>1997-02-27</td>56<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">haynes</span></td>57<td>adams</td>58<td>pratt through truss</td>59</tr>60<tr>61<td>colton 's crossing bridge</td>62<td>1997-02-27</td>63<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">lisbon</span></td>64<td>ransom</td>65<td>pratt through truss</td>66</tr>67<tr>68<td>crystal bridge</td>69<td>1997-05-30</td>70<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">crystal</span></td>71<td>pembina</td>72<td>concrete t - beam bridge</td>73</tr>74<tr>75<td>eastwood park bridge</td>76<td>1975-04-21</td>77<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">minot</span></td>78<td>ward</td>79<td>cantilever type</td>80</tr>81<tr>82<td>elliott bridge</td>83<td>1997-02-27</td>84<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">towner</span></td>85<td>mchenry</td>86<td>pratt through truss</td>87</tr>88<tr>89<td>fairview lift bridge</td>90<td>1997-03-14</td>91<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">cartwright</span></td>92<td>mckenzie</td>93<td>railroad lift bridge</td>94</tr>95<tr>96<td>grace city bridge</td>97<td>1997-02-27</td>98<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">grace city</span></td>99<td>foster</td>100<td>pratt through truss</td>101</tr>102<tr>103<td>great northern railway underpass</td>104<td>1997-02-27</td>105<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">stanley</span></td>106<td>mountrail</td>107<td>concrete deck girder bridge</td>108</tr>109<tr>110<td>knife river bridge near stanton</td>111<td>2001-04-25</td>112<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">stanton</span></td>113<td>mercer</td>114<td>pratt through truss</td>115</tr>116<tr>117<td>lisbon bridge</td>118<td>1997-02-27</td>119<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">lisbon</span></td>120<td>ransom</td>121<td>steel cantilever bean bridge</td>122</tr>123<tr>124<td>midland continental overpass</td>125<td>1997-02-27</td>126<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">jamestown</span></td>127<td>stutsman</td>128<td>steel cantilever beam bridge</td>129</tr>130<tr>131<td>midway bridge</td>132<td>1997-02-27</td>133<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">johnstown</span></td>134<td>grand forks</td>135<td>warren bedstead bridge</td>136</tr>137<tr>138<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">nesheim bridge</span></td>139<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1997-02-27</span></td>140<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">mcville</span></td>141<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">nelson</span></td>142<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">pratt through truss</span></td>143</tr>144<tr>145<td>new rockford bridge</td>146<td>1997-03-13</td>147<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">new rockford closed to traffic</span></td>148<td>eddy</td>149<td>warren through truss bridge</td>150</tr>151<tr>152<td>northwood bridge</td>153<td>1997-02-27</td>154<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">northwood</span></td>155<td>grand forks</td>156<td>pratt pony truss</td>157</tr>158<tr>159<td>norway bridge</td>160<td>1997-02-27</td>161<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">mayville</span></td>162<td>traill</td>163<td>pratt pony truss</td>164</tr>165<tr>166<td>ost valle bridge</td>167<td>1997-02-27</td>168<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">thompson</span></td>169<td>grand forks</td>170<td>pratt through truss</td>171</tr>172<tr>173<td>romness bridge</td>174<td>1997-02-27</td>175<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">cooperstown</span></td>176<td>griggs</td>177<td>pratt through truss</td>178</tr>179<tr>180<td>sorlie memorial bridge</td>181<td>1999-07-19</td>182<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">grand forks</span></td>183<td>grand forks</td>184<td>parker through truss bridge</td>185</tr>186<tr>187<td>viking bridge</td>188<td>1997-02-27</td>189<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">portland</span></td>190<td>traill</td>191<td>pratt through truss</td>192</tr>193<tr>194<td>west antelope bridge</td>195<td>1997-02-27</td>196<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">flora</span></td>197<td>benson</td>198<td>pratt pony truss bridge</td>199</tr>200<tr>201<td>west park bridge</td>202<td>1997-02-27</td>203<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">valley city</span></td>204<td>barnes</td>205<td>concrete false arch bridge</td>206</tr>207<tr>208<td>westgaard bridge</td>209<td>1997-02-27</td>210<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">voltaire</span></td>211<td>mchenry</td>212<td>pratt pony through truss</td>213</tr>214<tr>215<td>blanchard bridge</td>216<td>1997-02-27</td>217<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">blanchard</span></td>218<td>traill</td>219<td>pratt through truss</td>220</tr>221<tr>222<td>goose river bridge</td>223<td>1997-02-27</td>224<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">hillsboro</span></td>225<td>traill</td>226<td>pratt through truss</td>227</tr>228<tr>229<td>liberty memorial bridge</td>230<td>1997-03-11 removed 2009-03-25</td>231<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">bismarck</span></td>232<td>burleigh</td>233<td>warren - turner through truss</td>234</tr>235<tr>236<td>porter elliott bridge</td>237<td>1997-02-27</td>238<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">hillsboro</span></td>239<td>traill</td>240<td>warren through truss</td>241</tr>242<tr>243<td>portland park bridge</td>244<td>2004-09-23</td>245<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">portland</span></td>246<td>traill</td>247<td>steel through girder</td>248</tr>249<tr>250<td>rainbow arch bridge</td>251<td>2004-09-23</td>252<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">valley city</span></td>253<td>barnes</td>254<td>marsh rainbow arch</td>255</tr>256</table>257</div>258<hr>259<div class="step">260<div class="step-title">Step 2: Select rows where 'name' is 'goose river bridge'.</div>261<div id="step-0" class="content">262<table>263<tr>264<td>name</td>265<td>listed</td>266<td>location</td>267<td>county</td>268<td>type</td>269</tr>270<tr>271<td>nesheim bridge</td>272<td>1997-02-27</td>273<td>mcville</td>274<td>nelson</td>275<td>pratt through truss</td>276</tr>277</table>278</div>279</div>280<hr>281<div class="step">282<div class="step-title">Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.</div>283<div id="step-1" class="content">284<table>285<tr>286<td>name</td>287<td>listed</td>288<td>location</td>289<td>county</td>290<td>type</td>291</tr>292</table>293</div>294</div>295<hr>296<div class="step">297<div class="step-title">Final output table:</div>298<div id="step-2" class="content">299<table>300<tr>301<td>verification_result</td>302</tr>303<tr>304<td>FALSE</td>305</tr>306</table>307</div>308</div>309<hr>310<div class="step"><h3><span class="true">Prediction: FALSE </span></h3>311<h3>Ground-truth:</span> FALSE</h3></div>312</body></html>313