CREATE TABLE table_204_710 (id NUMBER, "model" CLOB, "origin" CLOB, "type" CLOB, "versions" CLOB, "in service" CLOB, "notes" CLOB)

how many aircraft does the united states have listed ?
SELECT COUNT(*) FROM table_204_710 WHERE "origin" = 'united states'
SELECT COUNT(*) FROM "table_204_710" WHERE "origin" = 'united states'