CREATE TABLE table_204_343 (id NUMBER, "nation" CLOB, "model" CLOB, "length" CLOB, "barrel length" CLOB, "weight" CLOB)

how many other models are the same length as the m1898 carbine ?
SELECT COUNT("model") FROM table_204_343 WHERE "model" <> 'm1898 carbine' AND "length" = (SELECT "length" FROM table_204_343 WHERE "model" = 'm1898 carbine')
SELECT COUNT("model") FROM "table_204_343" WHERE "length" = (SELECT "length" FROM "table_204_343" WHERE "model" = 'm1898 carbine') AND "model" <> 'm1898 carbine'