CREATE TABLE table_203_19 (id NUMBER, "number" NUMBER, "builder" CLOB, "type" CLOB, "date" NUMBER, "length" CLOB, "notes" CLOB)

what was the number of cars built by american car company ?
SELECT COUNT(*) FROM table_203_19 WHERE "builder" = 'american car company'
SELECT COUNT(*) FROM "table_203_19" WHERE "builder" = 'american car company'