CREATE TABLE table_203_485 (id NUMBER, "year" CLOB, "show" CLOB, "role" CLOB, "notes" CLOB)

how many shows were there in 2005 ?
SELECT COUNT("show") FROM table_203_485 WHERE "year" = 2005
SELECT COUNT("show") FROM "table_203_485" WHERE "year" = 2005