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> in tokyo , japan , hikaru sato 's match ended before round 2</h3>25<h3>Ground-truth:</span> TRUE</h3>26<h3>Input Table: katsuya inoue</h3>27<div class="step">28<div class="step">29<div class="step-title">Step 1: Select rows where 'location' is 'tokyo' and 'country' is 'japan'.</div>30<div id="step-1" class="content">31<table>32<tr>33<td>res</td>34<td>record</td>35<td>opponent</td>36<td>method</td>37<td>event</td>38<td>round</td>39<td>time</td>40<td>location</td>41</tr>42<tr>43<td>loss</td>44<td>19 - 9 - 4</td>45<td>naoyuki kotani</td>46<td>submission (armbar)</td>47<td>9999-01-01</td>48<td>1</td>49<td>9999-01-01</td>50<td>9999-01-01</td>51</tr>52<tr>53<td>loss</td>54<td>19 - 8 - 4</td>55<td>kota okazawa</td>56<td>ko (punch)</td>57<td>9999-01-01</td>58<td>1</td>59<td>9999-01-01</td>60<td>9999-01-01</td>61</tr>62<tr>63<td>win</td>64<td>19 - 7 - 4</td>65<td>katsuhiko nagata</td>66<td>decision (unanimous)</td>67<td>9999-01-01</td>68<td>3</td>69<td>9999-01-01</td>70<td>9999-01-01</td>71</tr>72<tr>73<td>loss</td>74<td>18 - 7 - 4</td>75<td>maximo blanco</td>76<td>tko (strikes)</td>77<td>9999-01-01</td>78<td>2</td>79<td>9999-01-01</td>80<td>9999-01-01</td>81</tr>82<tr>83<td>draw</td>84<td>18 - 6 - 4</td>85<td>mizuto hirota</td>86<td>draw</td>87<td>9999-01-01</td>88<td>3</td>89<td>9999-01-01</td>90<td>9999-01-01</td>91</tr>92<tr>93<td>win</td>94<td>17 - 6 - 3</td>95<td>koji oishi</td>96<td>decision (unanimous)</td>97<td>9999-01-01</td>98<td>3</td>99<td>9999-01-01</td>100<td>9999-01-01</td>101</tr>102<tr>103<td>win</td>104<td>18 - 6 - 3</td>105<td>daisuke hanazawa</td>106<td>decision (unanimous)</td>107<td>9999-01-01</td>108<td>3</td>109<td>9999-01-01</td>110<td>9999-01-01</td>111</tr>112<tr>113<td>loss</td>114<td>16 - 6 - 3</td>115<td>nick diaz</td>116<td>tko (corner stoppage)</td>117<td>9999-01-01</td>118<td>1</td>119<td>9999-01-01</td>120<td>9999-01-01</td>121</tr>122<tr>123<td>draw</td>124<td>16 - 5 - 3</td>125<td>djamal kurbanov</td>126<td>draw</td>127<td>9999-01-01</td>128<td>3</td>129<td>9999-01-01</td>130<td>9999-01-01</td>131</tr>132<tr>133<td>win</td>134<td>16 - 5 - 2</td>135<td>satoru kitaoka</td>136<td>decision (split)</td>137<td>9999-01-01</td>138<td>3</td>139<td>9999-01-01</td>140<td>9999-01-01</td>141</tr>142<tr>143<td>draw</td>144<td>15 - 5 - 2</td>145<td>shigetoshi iwase</td>146<td>draw</td>147<td>2007-01-01</td>148<td>3</td>149<td>9999-01-01</td>150<td>9999-01-01</td>151</tr>152<tr>153<td>win</td>154<td>15 - 5 - 1</td>155<td>fabricio nascimento</td>156<td>tko (punches)</td>157<td>2007-01-01</td>158<td>2</td>159<td>9999-01-01</td>160<td>9999-01-01</td>161</tr>162<tr>163<td>win</td>164<td>14 - 5 - 1</td>165<td>koji oishi</td>166<td>ko (punches)</td>167<td>9999-01-01</td>168<td>2</td>169<td>9999-01-01</td>170<td>9999-01-01</td>171</tr>172<tr>173<td>x loss</td>174<td>13 - 5 - 1</td>175<td>yoshiyuki yoshida</td>176<td>ko (punch)</td>177<td>9999-01-01</td>178<td>1</td>179<td>9999-01-01</td>180<td>9999-01-01</td>181</tr>182<tr>183<td>win</td>184<td>13 - 4 - 1</td>185<td>takefume hanai</td>186<td>tko (punches)</td>187<td>9999-01-01</td>188<td>2</td>189<td>9999-01-01</td>190<td>9999-01-01</td>191</tr>192<tr>193<td>x loss</td>194<td>12 - 4 - 1</td>195<td>daizo ishige</td>196<td>decision (unanimous)</td>197<td>9999-01-06</td>198<td>3</td>199<td>9999-01-01</td>200<td>9999-01-01</td>201</tr>202<tr>203<td>win</td>204<td>12 - 3 - 1</td>205<td>kim haeng ki</td>206<td>tko (punches)</td>207<td>9999-03-01</td>208<td>3</td>209<td>9999-01-01</td>210<td>9999-01-01</td>211</tr>212<tr>213<td>draw</td>214<td>11 - 3 - 1</td>215<td>satoru kitaoka</td>216<td>draw</td>217<td>9999-01-01</td>218<td>3</td>219<td>9999-01-01</td>220<td>9999-01-01</td>221</tr>222<tr>223<td>win</td>224<td>11 - 3</td>225<td>daisuke hanazawa</td>226<td>decision (majority)</td>227<td>9999-01-04</td>228<td>3</td>229<td>9999-01-01</td>230<td>9999-01-01</td>231</tr>232<tr>233<td>x loss</td>234<td>10 - 3</td>235<td>akira kikuchi</td>236<td>tko (punches)</td>237<td>9999-01-02</td>238<td>1</td>239<td>9999-01-01</td>240<td>9999-01-01</td>241</tr>242<tr>243<td>win</td>244<td>10 - 2</td>245<td>kenji arai</td>246<td>ko (punch)</td>247<td>9999-01-01</td>248<td>2</td>249<td>9999-01-01</td>250<td>9999-01-01</td>251</tr>252<tr>253<td>win</td>254<td>9 - 2</td>255<td>heath sims</td>256<td>tko (punches)</td>257<td>9999-01-01</td>258<td>1</td>259<td>9999-01-01</td>260<td>9999-01-01</td>261</tr>262<tr>263<td>win</td>264<td>8 - 2</td>265<td>kyle noke</td>266<td>decision (split)</td>267<td>9999-01-01</td>268<td>3</td>269<td>9999-01-01</td>270<td>9999-01-01</td>271</tr>272<tr>273<td>win</td>274<td>7 - 2</td>275<td>satoru kitaoka</td>276<td>decision (unanimous)</td>277<td>9999-01-01</td>278<td>3</td>279<td>9999-01-01</td>280<td>9999-01-01</td>281</tr>282<tr>283<td>win</td>284<td>6 - 2</td>285<td>takuya wada</td>286<td>decision (unanimous)</td>287<td>9999-01-01</td>288<td>3</td>289<td>9999-01-01</td>290<td>9999-01-01</td>291</tr>292<tr>293<td>win</td>294<td>5 - 2</td>295<td>hikaru sato</td>296<td>tko (punches)</td>297<td>9999-01-01</td>298<td>1</td>299<td>9999-01-01</td>300<td>9999-01-01</td>301</tr>302<tr>303<td>win</td>304<td>4 - 2</td>305<td>ichiro kanai</td>306<td>decision (majority)</td>307<td>9999-01-01</td>308<td>2</td>309<td>9999-01-01</td>310<td>9999-01-01</td>311</tr>312<tr>313<td>x loss</td>314<td>3 - 2</td>315<td>eiji ishikawa</td>316<td>decision (majority)</td>317<td>9999-01-01</td>318<td>2</td>319<td>9999-01-01</td>320<td>9999-01-01</td>321</tr>322<tr>323<td>win</td>324<td>3 - 1</td>325<td>taro minato</td>326<td>decision (unanimous)</td>327<td>9999-01-12</td>328<td>2</td>329<td>9999-01-01</td>330<td>9999-01-01</td>331</tr>332<tr>333<td>win</td>334<td>2 - 1</td>335<td>ichiro kanai</td>336<td>decision (unanimous)</td>337<td>9999-01-07</td>338<td>2</td>339<td>9999-01-01</td>340<td>9999-01-01</td>341</tr>342<tr>343<td>win</td>344<td>1 - 1</td>345<td>motohiro tachihara</td>346<td>decision (unanimous)</td>347<td>9999-01-05</td>348<td>2</td>349<td>9999-01-01</td>350<td>9999-01-01</td>351</tr>352<tr>353<td>x loss</td>354<td>0 - 1</td>355<td>yoshinori oniki</td>356<td>tko (strikes)</td>357<td>9999-01-04</td>358<td>1</td>359<td>9999-01-09</td>360<td>9999-01-01</td>361</tr>362</table>363</div>364<hr>365<div class="step">366<div class="step-title">Step 2: Select rows where 'opponent' is 'hikaru sato'.</div>367<div id="step-0" class="content">368<table>369<tr>370<td>res</td>371<td>record</td>372<td>opponent</td>373<td>method</td>374<td>event</td>375<td>round</td>376<td>time</td>377<td>location</td>378</tr>379</table>380</div>381</div>382<hr>383<div class="step">384<div class="step-title">Step 3: Select rows where 'round' is less than 2.</div>385<div id="step-1" class="content">386<table>387<tr>388<td>res</td>389<td>record</td>390<td>opponent</td>391<td>method</td>392<td>event</td>393<td>round</td>394<td>time</td>395<td>location</td>396</tr>397</table>398</div>399</div>400<hr>401<div class="step">402<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>403<div id="step-2" class="content">404<table>405<tr>406<td>res</td>407<td>record</td>408<td>opponent</td>409<td>method</td>410<td>event</td>411<td>round</td>412<td>time</td>413<td>location</td>414</tr>415</table>416</div>417</div>418<hr>419<div class="step">420<div class="step-title">Final output table:</div>421<div id="step-3" class="content">422<table>423<tr>424<td>verification_result</td>425</tr>426<tr>427<td>FALSE</td>428</tr>429</table>430</div>431</div>432<hr>433<div class="step"><h3><span class="false">Prediction: FALSE </span></h3>434<h3>Ground-truth:</span> TRUE</h3></div>435</body></html>436