CREATE TABLE table_204_459 (id NUMBER, "date" CLOB, "time" CLOB, "opponent" CLOB, "site" CLOB, "tv" CLOB, "result" CLOB, "attendance" NUMBER, "record" CLOB)

how many games were played against grand canyon ?
SELECT COUNT(*) FROM table_204_459 WHERE "opponent" = 'grand canyon'
SELECT COUNT(*) FROM "table_204_459" WHERE "opponent" = 'grand canyon'