luulinh90s/Tabular-LLM-Study-Debugging

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> coherence is the name when windows and web interface are partial</h3>25<h3>Ground-truth:</span> FALSE</h3>26<h3>Input Table: comparison of upnp av media servers</h3>27<div class="step">28<div class="step">29<div class="step-title">Step 1: Select rows where 'windows' is 'partial'.</div>30<div id="step-1" class="content">31<table>32<tr>33<td>name</td>34<td>license</td>35<td>os_x</td>36<td>unix___like</td>37<td>windows</td>38<td>web_interface</td>39</tr>40<tr>41<td>360 media server</td>42<td>gpl</td>43<td>no</td>44<td>yes</td>45<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>46<td>yes</td>47</tr>48<tr>49<td>avia media player</td>50<td>prop</td>51<td>no</td>52<td>no</td>53<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">no</span></td>54<td>no</td>55</tr>56<tr>57<td>brisa</td>58<td>mit</td>59<td>partial</td>60<td>partial</td>61<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">no</span></td>62<td>yes</td>63</tr>64<tr>65<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">coherence</span></td>66<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">mit</span></td>67<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">partial</span></td>68<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">partial</span></td>69<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">partial</span></td>70<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>71</tr>72<tr>73<td>divx</td>74<td>prop</td>75<td>yes</td>76<td>no</td>77<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>78<td>no</td>79</tr>80<tr>81<td>elgato eyeconnect</td>82<td>prop</td>83<td>yes</td>84<td>no</td>85<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">no</span></td>86<td>no</td>87</tr>88<tr>89<td>foobar2000</td>90<td>prop</td>91<td>no</td>92<td>no</td>93<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>94<td>no</td>95</tr>96<tr>97<td>fuppes</td>98<td>gpl</td>99<td>yes</td>100<td>yes</td>101<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>102<td>yes</td>103</tr>104<tr>105<td>geexbox ushare</td>106<td>gpl</td>107<td>no</td>108<td>yes</td>109<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">no</span></td>110<td>yes</td>111</tr>112<tr>113<td>gmediaserver</td>114<td>gpl</td>115<td>no</td>116<td>yes</td>117<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">no</span></td>118<td>no</td>119</tr>120<tr>121<td>home media center</td>122<td>gplv2</td>123<td>no</td>124<td>no</td>125<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>126<td>yes</td>127</tr>128<tr>129<td>isedora media server</td>130<td>prop</td>131<td>yes</td>132<td>no</td>133<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>134<td>yes</td>135</tr>136<tr>137<td>jriver media center</td>138<td>prop</td>139<td>no</td>140<td>no</td>141<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>142<td>yes</td>143</tr>144<tr>145<td>kooraroo media</td>146<td>prop</td>147<td>yes</td>148<td>yes</td>149<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>150<td>yes</td>151</tr>152<tr>153<td>lximedia</td>154<td>gpl</td>155<td>yes</td>156<td>yes</td>157<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>158<td>no</td>159</tr>160<tr>161<td>majestic media server</td>162<td>prop</td>163<td>yes</td>164<td>no</td>165<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">no</span></td>166<td>no</td>167</tr>168<tr>169<td>mediatomb</td>170<td>gpl</td>171<td>partial</td>172<td>yes</td>173<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">no</span></td>174<td>yes</td>175</tr>176<tr>177<td>minidlna</td>178<td>gpl / bsd</td>179<td>partial</td>180<td>yes</td>181<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>182<td>partial</td>183</tr>184<tr>185<td>mezzmo</td>186<td>prop</td>187<td>no</td>188<td>no</td>189<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>190<td>no</td>191</tr>192<tr>193<td>myihome</td>194<td>prop</td>195<td>yes</td>196<td>yes</td>197<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>198<td>no</td>199</tr>200<tr>201<td>mythtv with upnp</td>202<td>gpl</td>203<td>yes</td>204<td>yes</td>205<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">no</span></td>206<td>yes</td>207</tr>208<tr>209<td>nullriver medialink</td>210<td>prop</td>211<td>yes</td>212<td>no</td>213<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">no</span></td>214<td>no</td>215</tr>216<tr>217<td>playon</td>218<td>prop</td>219<td>no</td>220<td>no</td>221<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>222<td>yes</td>223</tr>224<tr>225<td>plex</td>226<td>prop</td>227<td>yes</td>228<td>yes</td>229<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>230<td>yes</td>231</tr>232<tr>233<td>ps3 media server</td>234<td>gpl</td>235<td>yes</td>236<td>yes</td>237<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>238<td>yes</td>239</tr>240<tr>241<td>pymeds</td>242<td>mit</td>243<td>partial</td>244<td>partial</td>245<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">no</span></td>246<td>no</td>247</tr>248<tr>249<td>rygel</td>250<td>lgplv2</td>251<td>no</td>252<td>yes</td>253<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">no</span></td>254<td>no</td>255</tr>256<tr>257<td>rivet</td>258<td>prop</td>259<td>yes</td>260<td>no</td>261<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">no</span></td>262<td>no</td>263</tr>264<tr>265<td>serviio</td>266<td>prop</td>267<td>yes</td>268<td>yes</td>269<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>270<td>yes</td>271</tr>272<tr>273<td>simplecenter premium</td>274<td>prop</td>275<td>no</td>276<td>no</td>277<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>278<td>yes</td>279</tr>280<tr>281<td>skifta</td>282<td>prop</td>283<td>yes</td>284<td>yes</td>285<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>286<td>no</td>287</tr>288<tr>289<td>songbird</td>290<td>gplv2</td>291<td>yes</td>292<td>no</td>293<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>294<td>no</td>295</tr>296<tr>297<td>tvble</td>298<td>prop</td>299<td>no</td>300<td>no</td>301<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>302<td>no</td>303</tr>304<tr>305<td>tversity</td>306<td>prop</td>307<td>no</td>308<td>no</td>309<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>310<td>yes</td>311</tr>312<tr>313<td>tvmobili</td>314<td>prop</td>315<td>yes</td>316<td>yes</td>317<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>318<td>yes</td>319</tr>320<tr>321<td>tvshare</td>322<td>prop</td>323<td>no</td>324<td>no</td>325<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>326<td>no</td>327</tr>328<tr>329<td>twonkyserver</td>330<td>prop</td>331<td>yes</td>332<td>yes</td>333<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>334<td>yes</td>335</tr>336<tr>337<td>universal media server</td>338<td>gpl</td>339<td>yes</td>340<td>yes</td>341<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>342<td>yes</td>343</tr>344<tr>345<td>windows media connect</td>346<td>prop</td>347<td>no</td>348<td>no</td>349<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>350<td>no</td>351</tr>352<tr>353<td>wild media server</td>354<td>prop</td>355<td>yes</td>356<td>yes</td>357<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>358<td>yes</td>359</tr>360<tr>361<td>xbmc media center</td>362<td>gpl</td>363<td>yes</td>364<td>yes</td>365<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">yes</span></td>366<td>yes</td>367</tr>368<tr>369<td>xupnpd</td>370<td>gplv2</td>371<td>no</td>372<td>yes</td>373<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">no</span></td>374<td>yes</td>375</tr>376<tr>377<td>yazsoft playback</td>378<td>prop</td>379<td>yes</td>380<td>no</td>381<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">no</span></td>382<td>no</td>383</tr>384<tr>385<td>name</td>386<td>license</td>387<td>os x</td>388<td>unix - like</td>389<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">windows</span></td>390<td>web interface</td>391</tr>392</table>393</div>394<hr>395<div class="step">396<div class="step-title">Step 2: Select rows where 'web_interface' is 'partial'.</div>397<div id="step-0" class="content">398<table>399<tr>400<td>name</td>401<td>license</td>402<td>os_x</td>403<td>unix___like</td>404<td>windows</td>405<td>web_interface</td>406</tr>407<tr>408<td>coherence</td>409<td>mit</td>410<td>partial</td>411<td>partial</td>412<td>partial</td>413<td>yes</td>414</tr>415</table>416</div>417</div>418<hr>419<div class="step">420<div class="step-title">Step 3: Select rows where 'name' is 'coherence'.</div>421<div id="step-1" class="content">422<table>423<tr>424<td>name</td>425<td>license</td>426<td>os_x</td>427<td>unix___like</td>428<td>windows</td>429<td>web_interface</td>430</tr>431</table>432</div>433</div>434<hr>435<div class="step">436<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>437<div id="step-2" class="content">438<table>439<tr>440<td>name</td>441<td>license</td>442<td>os_x</td>443<td>unix___like</td>444<td>windows</td>445<td>web_interface</td>446</tr>447</table>448</div>449</div>450<hr>451<div class="step">452<div class="step-title">Final output table:</div>453<div id="step-3" class="content">454<table>455<tr>456<td>verification_result</td>457</tr>458<tr>459<td>FALSE</td>460</tr>461</table>462</div>463</div>464<hr>465<div class="step"><h3><span class="true">Prediction: FALSE </span></h3>466<h3>Ground-truth:</span> FALSE</h3></div>467</body></html>468