CREATE TABLE table_202_102 (id NUMBER, "battle ,  siege ,  or offensive" CLOB, "conflict" CLOB, "dates" CLOB, "estimated number of americans killed" CLOB)

how many battles resulted between 3,000 and 4,200 estimated americans killed ?
SELECT COUNT("battle, siege, or offensive") FROM table_202_102 WHERE "estimated number of americans killed" > 3000 AND "estimated number of americans killed" < 4200
SELECT COUNT("battle, siege, or offensive") FROM "table_202_102" WHERE "estimated number of americans killed" < 4200 AND "estimated number of americans killed" > 3000