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> kansas city had no post - season record in 2013</h3>25<h3>Ground-truth:</span> TRUE</h3>26<h3>Input Table: lexington legends</h3>27<div class="step">28<div class="step">29<div class="step-title">Step 1: Select rows where 'mlb_affiliate' is 'kansas city'.</div>30<div id="step-1" class="content">31<table>32<tr>33<td>season</td>34<td>manager</td>35<td>record</td>36<td>win</td>37<td>post___season_record</td>38<td>post___season_win</td>39<td>mlb_affiliate</td>40</tr>41<tr>42<td>2001</td>43<td>joe cannon</td>44<td>92 - 48</td>45<td>657</td>46<td>4 - 0</td>47<td>1.000</td>48<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">houston</span></td>49</tr>50<tr>51<td>2002</td>52<td>joe cannon</td>53<td>81 - 59</td>54<td>579</td>55<td>-</td>56<td>-</td>57<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">houston</span></td>58</tr>59<tr>60<td>2003 ♦</td>61<td>russ nixon</td>62<td>75 - 63</td>63<td>543</td>64<td>0 - 2</td>65<td>000</td>66<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">houston</span></td>67</tr>68<tr>69<td>2004</td>70<td>iván dejesús</td>71<td>68 - 72</td>72<td>486</td>73<td>-</td>74<td>-</td>75<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">houston</span></td>76</tr>77<tr>78<td>2005</td>79<td>tim bogar</td>80<td>81 - 58</td>81<td>583</td>82<td>-</td>83<td>-</td>84<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">houston</span></td>85</tr>86<tr>87<td>2006 ♦</td>88<td>jack lind</td>89<td>75 - 63</td>90<td>543</td>91<td>0 - 2</td>92<td>000</td>93<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">houston</span></td>94</tr>95<tr>96<td>2007</td>97<td>gregg langbehn</td>98<td>59 - 81</td>99<td>421</td>100<td>-</td>101<td>-</td>102<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">houston</span></td>103</tr>104<tr>105<td>2008</td>106<td>gregg langbehn</td>107<td>45 - 93</td>108<td>326</td>109<td>-</td>110<td>-</td>111<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">houston</span></td>112</tr>113<tr>114<td>2009</td>115<td>tom lawless</td>116<td>68 - 72</td>117<td>486</td>118<td>-</td>119<td>-</td>120<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">houston</span></td>121</tr>122<tr>123<td>2010</td>124<td>rodney linares</td>125<td>71 - 68</td>126<td>511</td>127<td>-</td>128<td>-</td>129<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">houston</span></td>130</tr>131<tr>132<td>2011</td>133<td>rodney linares</td>134<td>59 - 79</td>135<td>428</td>136<td>-</td>137<td>-</td>138<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">houston</span></td>139</tr>140<tr>141<td>2012</td>142<td>iván dejesús</td>143<td>69 - 69</td>144<td>500</td>145<td>-</td>146<td>-</td>147<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">houston</span></td>148</tr>149<tr>150<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">2013</span></td>151<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">brian buchanan</span></td>152<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">44 - 42</span></td>153<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">512</span></td>154<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>155<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>156<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">kansas city</span></td>157</tr>158</table>159</div>160<hr>161<div class="step">162<div class="step-title">Step 2: Select rows where 'season' is 2013.</div>163<div id="step-0" class="content">164<table>165<tr>166<td>season</td>167<td>manager</td>168<td>record</td>169<td>win</td>170<td>post___season_record</td>171<td>post___season_win</td>172<td>mlb_affiliate</td>173</tr>174<tr>175<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">2013</span></td>176<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">brian buchanan</span></td>177<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">44 - 42</span></td>178<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">512</span></td>179<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>180<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">-</span></td>181<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">kansas city</span></td>182</tr>183</table>184</div>185</div>186<hr>187<div class="step">188<div class="step-title">Step 3: Select rows where 'post___season_record' is not '-'.</div>189<div id="step-1" class="content">190<table>191<tr>192<td>season</td>193<td>manager</td>194<td>record</td>195<td>win</td>196<td>post___season_record</td>197<td>post___season_win</td>198<td>mlb_affiliate</td>199</tr>200<tr>201<td>2013</td>202<td>brian buchanan</td>203<td>44 - 42</td>204<td>512</td>205<td>-</td>206<td>-</td>207<td>kansas city</td>208</tr>209</table>210</div>211</div>212<hr>213<div class="step">214<div class="step-title">Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 0, otherwise return FALSE.</div>215<div id="step-2" class="content">216<table>217<tr>218<td>season</td>219<td>manager</td>220<td>record</td>221<td>win</td>222<td>post___season_record</td>223<td>post___season_win</td>224<td>mlb_affiliate</td>225</tr>226</table>227</div>228</div>229<hr>230<div class="step">231<div class="step-title">Final output table:</div>232<div id="step-3" class="content">233<table>234<tr>235<td>verification_result</td>236</tr>237<tr>238<td>TRUE</td>239</tr>240</table>241</div>242</div>243<hr>244<div class="step"><h3><span class="true">Prediction: TRUE </span></h3>245<h3>Ground-truth:</span> TRUE</h3></div>246</body></html>247