CREATE TABLE table_204_476 (id NUMBER, "name" CLOB, "date built" NUMBER, "builder" CLOB, "works no." NUMBER, "wheels" CLOB, "cylinders" CLOB, "notes" CLOB, "withdrawn" NUMBER)

how many were built in 1847 ?
SELECT COUNT(*) FROM table_204_476 WHERE "date built" = 1847
SELECT COUNT(*) FROM "table_204_476" WHERE "date built" = 1847