luulinh90s/Tabular-LLM-Study-Preference-Ranking

1 2<html><head>3<style>4body { font-family: Arial, sans-serif; margin: 20px; }5h1 { text-align: center; }6.cot-title { color: blue; }7.pos-title { color: green; }8h2 { color: black; text-align: left; }9h3 { color: black; text-align: left; }10h4 { color: darkslategray; }11table { width: 100%; border-collapse: collapse; margin: 20px 0; }12table, th, td { border: 1px solid #ddd; padding: 8px; }13th { background-color: #f2f2f2; }14tr:nth-child(even) { background-color: #f9f9f9; }15.highlight { background-color: #ffffcc; }16.true { color: green; }17.false { color: red; }18.highlighted-cell { background-color: yellow; cursor: pointer; }19.step-title { background-color: #f1f1f1; color: #444; padding: 10px; margin: 10px 0; font-size: 18px; border-left: 4px solid #888; }20.step { display: block; }21.sql-command { background-color: #f0f0f0; padding: 10px; border-left: 4px solid #4CAF50; font-family: monospace; white-space: pre-wrap; }22</style>23</head><body>24<hr>25<h3><span>Statement:</span> for the class vesuvius with wheel arrangement 2 - 4 - 0 , the quantity made was 32 and quantity preserved was 0</h3>26<h3>Input Table: locomotives of the southern railway</h3>27<div class="step">28<table>29<tr><td>class</td><td>wheel_arrangement</td><td>manufacturer</td><td>year_made</td><td>quantity_made</td><td>quantity_preserved</td><td>year_(s)_withdrawn</td></tr><tr><td>joseph hamilton beattie (1850 - 1871)</td><td>joseph hamilton beattie (1850 - 1871)</td><td>joseph hamilton beattie (1850 - 1871)</td><td>joseph hamilton beattie (1850 - 1871)</td><td>joseph hamilton beattie (1850 - 1871)</td><td>joseph hamilton beattie (1850 - 1871)</td><td>joseph hamilton beattie (1850 - 1871)</td></tr><tr><td>hercules</td><td>2 - 4 - 0</td><td>nine elms works</td><td>1851 - 1854</td><td>15</td><td>0</td><td>1875 - 1884</td></tr><tr><td>tartar</td><td>2 - 2 - 2wt</td><td>sharp brothers</td><td>1852</td><td>6</td><td>0</td><td>1871 - 1874</td></tr><tr><td>sussex</td><td>2 - 2 - 2wt</td><td>nine elms works</td><td>1852</td><td>8</td><td>0</td><td>1871 - 1876</td></tr><tr><td>canute</td><td>2 - 2 - 2</td><td>nine elms works</td><td>1855 - 1859</td><td>12</td><td>0</td><td>1875 - 1885</td></tr><tr><td>saxon</td><td>2 - 4 - 0</td><td>nine elms works</td><td>1855 - 1857</td><td>12</td><td>0</td><td>1877 - 1885</td></tr><tr><td>chaplin</td><td>2 - 2 - 2wt</td><td>nine elms works</td><td>1856</td><td>3</td><td>0</td><td>1876 - 1877</td></tr><tr><td>minerva</td><td>2 - 4 - 0wt</td><td>nine elms works</td><td>1856</td><td>3</td><td>0</td><td>1874 - 1883</td></tr><tr><td>nelson</td><td>2 - 4 - 0wt</td><td>nine elms works</td><td>1858</td><td>3</td><td>0</td><td>1882 - 1885</td></tr><tr><td>nile</td><td>2 - 4 - 0wt</td><td>nine elms works</td><td>1859</td><td>3</td><td>0</td><td>1882</td></tr><tr><td>tweed</td><td>2 - 4 - 0</td><td>nine elms works</td><td>1858 - 1859</td><td>6</td><td>0</td><td>1877 - 1879</td></tr><tr><td>undine</td><td>2 - 4 - 0</td><td>nine elms works</td><td>1859 - 60</td><td>12</td><td>0</td><td>1884 - 1886</td></tr><tr><td>clyde</td><td>2 - 4 - 0</td><td>nine elms works</td><td>1859 - 1868</td><td>13</td><td>0</td><td>1883 - 1899</td></tr><tr><td>gem</td><td>2 - 4 - 0</td><td>nine elms works</td><td>1862 - 1863</td><td>6</td><td>0</td><td>1884 - 1885</td></tr><tr><td>eagle</td><td>2 - 4 - 0</td><td>nine elms works</td><td>1862</td><td>3</td><td>0</td><td>1885 - 1886</td></tr><tr><td>falcon</td><td>2 - 4 - 0</td><td>nine elms works</td><td>1863 - 1867</td><td>17</td><td>0</td><td>1882 - 1898</td></tr><tr><td>177</td><td>2 - 4 - 0wt</td><td>beyer , peacock & co (82) nine elms works (3)</td><td>1863 - 1875</td><td>85</td><td>2</td><td>1886 - 1899 , 1962</td></tr><tr><td>lion</td><td>0 - 6 - 0</td><td>nine elms works</td><td>1863 - 1873</td><td>38</td><td>0</td><td>1886 - 1900</td></tr><tr><td>volcano</td><td>2 - 4 - 0</td><td>nine elms works</td><td>1866 - 1873</td><td>18</td><td>0</td><td>1886 - 1897</td></tr><tr><td>221</td><td>0 - 6 - 0</td><td>beyer , peacock & co</td><td>1866 - 1873</td><td>24</td><td>0</td><td>1891 - 1924</td></tr><tr><td>231</td><td>2 - 4 - 0</td><td>beyer , peacock & co</td><td>1866</td><td>6</td><td>0</td><td>1892 - 1899</td></tr><tr><td>vesuvius</td><td>2 - 4 - 0</td><td>nine elms works</td><td>1869 - 1875</td><td>32</td><td>0</td><td>1893 - 1899</td></tr>30</table>31</div>32<h3>SQL Command:</h3>33<div class="sql-command">SELECT 34    CASE 35        WHEN (SELECT quantity_made FROM table_sql WHERE class = 'vesuvius' AND wheel_arrangement = '2 - 4 - 0') = 32 36             AND (SELECT quantity_preserved FROM table_sql WHERE class = 'vesuvius' AND wheel_arrangement = '2 - 4 - 0') = 0 37        THEN 'TRUE' 38        ELSE 'FALSE' 39    END;</div>40</body></html>41