Apppublic
luulinh90s/Tabular-LLM-Study-Debugging

sourceHugging Facemitupdated 2y agoView on Hugging Face
0likes
test-191.html363 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<h1 class="pos-title">Plan-of-SQLs (Ours)</h1>23<hr>24<h3><span>Statement:</span> all 4 test matches took place in october of 1978</h3>25<h3>Ground-truth:</span> FALSE</h3>26<h3>Input Table: </h3>27<div class="step">28<div class="step">29<div class="step-title">Step 1: Select rows where 'status' is 'test match'.</div>30<div id="step-1" class="content">31<table>32<tr>33<td>opposing_team</td>34<td>against</td>35<td>date</td>36<td>venue</td>37<td>status</td>38</tr>39<tr>40<td>cambridge university</td>41<td>12</td>42<td>1978-10-18</td>43<td>grange road , cambridge</td>44<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tour match</span></td>45</tr>46<tr>47<td>cardiff</td>48<td>7</td>49<td>1978-10-21</td>50<td>cardiff arms park , cardiff</td>51<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tour match</span></td>52</tr>53<tr>54<td>west wales xv</td>55<td>7</td>56<td>1978-10-25</td>57<td>st helen 's , swansea</td>58<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tour match</span></td>59</tr>60<tr>61<td>london counties</td>62<td>12</td>63<td>1978-10-28</td>64<td>twickenham , london</td>65<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tour match</span></td>66</tr>67<tr>68<td>munster</td>69<td>12</td>70<td>1978-10-31</td>71<td>thomond park , limerick</td>72<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tour match</span></td>73</tr>74<tr>75<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">ireland</span></td>76<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">6</span></td>77<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1978-11-04</span></td>78<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">lansdowne road , dublin</span></td>79<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">test match</span></td>80</tr>81<tr>82<td>ulster</td>83<td>7</td>84<td>1978-11-07</td>85<td>ravenhill , belfast</td>86<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tour match</span></td>87</tr>88<tr>89<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">wales</span></td>90<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">12</span></td>91<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1978-11-01</span></td>92<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">cardiff arms park , cardiff</span></td>93<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">test match</span></td>94</tr>95<tr>96<td>south and south - west counties</td>97<td>0</td>98<td>1978-11-15</td>99<td>memorial ground , bristol</td>100<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tour match</span></td>101</tr>102<tr>103<td>midland counties</td>104<td>15</td>105<td>1978-11-18</td>106<td>welford road , leicester</td>107<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tour match</span></td>108</tr>109<tr>110<td>combined services</td>111<td>6</td>112<td>1978-11-21</td>113<td>aldershot military stadium , aldershot</td>114<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tour match</span></td>115</tr>116<tr>117<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">england</span></td>118<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">6</span></td>119<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">1978-11-25</span></td>120<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">twickenham , london</span></td>121<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">test match</span></td>122</tr>123<tr>124<td>monmouthshire</td>125<td>9</td>126<td>1978-11-29</td>127<td>rodney parade , newport</td>128<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tour match</span></td>129</tr>130<tr>131<td>north of england</td>132<td>6</td>133<td>1978-12-02</td>134<td>birkenhead park , birkenhead</td>135<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tour match</span></td>136</tr>137<tr>138<td>north and midland of scotland</td>139<td>3</td>140<td>1978-12-05</td>141<td>linksfield stadium , aberdeen</td>142<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tour match</span></td>143</tr>144<tr>145<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">scotland</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;">1978-12-09</span></td>148<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">murrayfield , edinburgh</span></td>149<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">test match</span></td>150</tr>151<tr>152<td>bridgend</td>153<td>6</td>154<td>1978-12-13</td>155<td>brewery field , bridgend</td>156<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tour match</span></td>157</tr>158<tr>159<td>barbarians</td>160<td>16</td>161<td>1978-12-16</td>162<td>cardiff arms park , cardiff</td>163<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">tour match</span></td>164</tr>165</table>166</div>167<hr>168<div class="step">169<div class="step-title">Step 2: Extract the month from the 'date' column to add column 'month' to existing table.</div>170<div id="step-0" class="content">171<table>172<tr>173<td>opposing_team</td>174<td>against</td>175<td>date</td>176<td>venue</td>177<td>status</td>178</tr>179<tr>180<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">ireland</span></td>181<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">6</span></td>182<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1978-11-04</span></td>183<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">lansdowne road , dublin</span></td>184<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">test match</span></td>185</tr>186<tr>187<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">wales</span></td>188<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">12</span></td>189<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1978-11-01</span></td>190<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">cardiff arms park , cardiff</span></td>191<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">test match</span></td>192</tr>193<tr>194<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">england</span></td>195<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">6</span></td>196<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1978-11-25</span></td>197<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">twickenham , london</span></td>198<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">test match</span></td>199</tr>200<tr>201<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">scotland</span></td>202<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">9</span></td>203<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1978-12-09</span></td>204<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">murrayfield , edinburgh</span></td>205<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">test match</span></td>206</tr>207</table>208</div>209</div>210<hr>211<div class="step">212<div class="step-title">Step 3: Extract the year from the 'date' column to add column 'year' to existing table.</div>213<div id="step-1" class="content">214<table>215<tr>216<td>opposing_team</td>217<td>against</td>218<td>date</td>219<td>venue</td>220<td>status</td>221<td>month</td>222</tr>223<tr>224<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">ireland</span></td>225<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">6</span></td>226<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1978-11-04</span></td>227<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">lansdowne road , dublin</span></td>228<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">test match</span></td>229<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">11</span></td>230</tr>231<tr>232<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">wales</span></td>233<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">12</span></td>234<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1978-11-01</span></td>235<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">cardiff arms park , cardiff</span></td>236<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">test match</span></td>237<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">11</span></td>238</tr>239<tr>240<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">england</span></td>241<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">6</span></td>242<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1978-11-25</span></td>243<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">twickenham , london</span></td>244<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">test match</span></td>245<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">11</span></td>246</tr>247<tr>248<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">scotland</span></td>249<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">9</span></td>250<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">1978-12-09</span></td>251<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">murrayfield , edinburgh</span></td>252<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">test match</span></td>253<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">12</span></td>254</tr>255</table>256</div>257</div>258<hr>259<div class="step">260<div class="step-title">Step 4: Select rows where 'month' is 'October'.</div>261<div id="step-2" class="content">262<table>263<tr>264<td>opposing_team</td>265<td>against</td>266<td>date</td>267<td>venue</td>268<td>status</td>269<td>month</td>270<td>year</td>271</tr>272<tr>273<td>ireland</td>274<td>6</td>275<td>1978-11-04</td>276<td>lansdowne road , dublin</td>277<td>test match</td>278<td>11</td>279<td>1978</td>280</tr>281<tr>282<td>wales</td>283<td>12</td>284<td>1978-11-01</td>285<td>cardiff arms park , cardiff</td>286<td>test match</td>287<td>11</td>288<td>1978</td>289</tr>290<tr>291<td>england</td>292<td>6</td>293<td>1978-11-25</td>294<td>twickenham , london</td>295<td>test match</td>296<td>11</td>297<td>1978</td>298</tr>299<tr>300<td>scotland</td>301<td>9</td>302<td>1978-12-09</td>303<td>murrayfield , edinburgh</td>304<td>test match</td>305<td>12</td>306<td>1978</td>307</tr>308</table>309</div>310</div>311<hr>312<div class="step">313<div class="step-title">Step 5: Select rows where 'year' is 1978.</div>314<div id="step-3" class="content">315<table>316<tr>317<td>opposing_team</td>318<td>against</td>319<td>date</td>320<td>venue</td>321<td>status</td>322<td>month</td>323<td>year</td>324</tr>325</table>326</div>327</div>328<hr>329<div class="step">330<div class="step-title">Step 6: Use a `CASE` statement to return TRUE if the number of rows is equal to 4, otherwise return FALSE.</div>331<div id="step-4" class="content">332<table>333<tr>334<td>opposing_team</td>335<td>against</td>336<td>date</td>337<td>venue</td>338<td>status</td>339<td>month</td>340<td>year</td>341</tr>342</table>343</div>344</div>345<hr>346<div class="step">347<div class="step-title">Final output table:</div>348<div id="step-5" class="content">349<table>350<tr>351<td>verification_result</td>352</tr>353<tr>354<td>FALSE</td>355</tr>356</table>357</div>358</div>359<hr>360<div class="step"><h3><span class="true">Prediction: FALSE </span></h3>361<h3>Ground-truth:</span> FALSE</h3></div>362</body></html>363