CREATE TABLE table_204_15 (id NUMBER, "year" NUMBER, "date" CLOB, "venue" CLOB, "city" CLOB, "country" CLOB, "notes" CLOB)

how many times is usa listed as the country ?
SELECT COUNT(*) FROM table_204_15 WHERE "country" = 'usa'
SELECT COUNT(*) FROM "table_204_15" WHERE "country" = 'usa'