CREATE TABLE table_203_9 (id NUMBER, "state" CLOB, "last execution date" CLOB, "name" CLOB, "crime" CLOB, "method" CLOB)

how many states had their last execution take place in 1997 ?
SELECT COUNT("state") FROM table_203_9 WHERE "last execution date" = 1997
SELECT COUNT("state") FROM "table_203_9" WHERE "last execution date" = 1997