CREATE TABLE table_204_867 (id NUMBER, "number" NUMBER, "date" CLOB, "name" CLOB, "age\ ( at execution ) " NUMBER, "age\ ( at offense ) " NUMBER, "race" CLOB, "state" CLOB, "method" CLOB)

what is the total number of women executed between 2000 and 2010 ?
SELECT COUNT("name") FROM table_204_867 WHERE "date" >= 2000 AND "date" <= 2010
SELECT COUNT("name") FROM "table_204_867" WHERE "date" <= 2010 AND "date" >= 2000