CREATE TABLE table_204_235 (id NUMBER, "season" CLOB, "team" CLOB, "country" CLOB, "competition" CLOB, "matches" NUMBER, "goals" NUMBER)

what was the number of goals he scored in 2005 ?
SELECT "goals" FROM table_204_235 WHERE "season" = 2005
SELECT "goals" FROM "table_204_235" WHERE "season" = 2005