Plan-of-SQLs (Ours)


Statement: for the class vesuvius with wheel arrangement 2 - 4 - 0 , the quantity made was 32 and quantity preserved was 0

Ground-truth: TRUE

Input Table: locomotives of the southern railway

Step 1: Select rows where 'class' is 'vesuvius' and 'wheel_arrangement' is '2 - 4 - 0'.
class wheel_arrangement manufacturer year_made quantity_made quantity_preserved year__s__withdrawn
joseph hamilton beattie (1850 - 1871) joseph hamilton beattie (1850 - 1871) joseph hamilton beattie (1850 - 1871) joseph hamilton beattie (1850 - 1871) joseph hamilton beattie (1850 - 1871) joseph hamilton beattie (1850 - 1871) joseph hamilton beattie (1850 - 1871)
hercules 2 - 4 - 0 nine elms works 1851 - 1854 15 0 1875 - 1884
tartar 2 - 2 - 2wt sharp brothers 1852 6 0 1871 - 1874
sussex 2 - 2 - 2wt nine elms works 1852 8 0 1871 - 1876
canute 2 - 2 - 2 nine elms works 1855 - 1859 12 0 1875 - 1885
saxon 2 - 4 - 0 nine elms works 1855 - 1857 12 0 1877 - 1885
chaplin 2 - 2 - 2wt nine elms works 1856 3 0 1876 - 1877
minerva 2 - 4 - 0wt nine elms works 1856 3 0 1874 - 1883
nelson 2 - 4 - 0wt nine elms works 1858 3 0 1882 - 1885
nile 2 - 4 - 0wt nine elms works 1859 3 0 1882
tweed 2 - 4 - 0 nine elms works 1858 - 1859 6 0 1877 - 1879
undine 2 - 4 - 0 nine elms works 1859 - 60 12 0 1884 - 1886
clyde 2 - 4 - 0 nine elms works 1859 - 1868 13 0 1883 - 1899
gem 2 - 4 - 0 nine elms works 1862 - 1863 6 0 1884 - 1885
eagle 2 - 4 - 0 nine elms works 1862 3 0 1885 - 1886
falcon 2 - 4 - 0 nine elms works 1863 - 1867 17 0 1882 - 1898
177 2 - 4 - 0wt beyer , peacock & co (82) nine elms works (3) 1863 - 1875 85 2 1886 - 1899 , 1962
lion 0 - 6 - 0 nine elms works 1863 - 1873 38 0 1886 - 1900
volcano 2 - 4 - 0 nine elms works 1866 - 1873 18 0 1886 - 1897
221 0 - 6 - 0 beyer , peacock & co 1866 - 1873 24 0 1891 - 1924
231 2 - 4 - 0 beyer , peacock & co 1866 6 0 1892 - 1899
vesuvius 2 - 4 - 0 nine elms works 1869 - 1875 32 0 1893 - 1899

Step 2: Select rows where 'quantity_made' is 32 and 'quantity_preserved' is 0.
class wheel_arrangement manufacturer year_made quantity_made quantity_preserved year__s__withdrawn
vesuvius 2 - 4 - 0 nine elms works 1869 - 1875 32 0 1893 - 1899

Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
class wheel_arrangement manufacturer year_made quantity_made quantity_preserved year__s__withdrawn
vesuvius 2 - 4 - 0 nine elms works 1869 - 1875 32 0 1893 - 1899

Final output table:
verification_result
TRUE

Prediction: TRUE

Ground-truth: TRUE