CREATE TABLE table_204_27 (id NUMBER, "name" CLOB, "position" CLOB, "year" CLOB, "league\ apps" NUMBER, "league\ goals" NUMBER, "total\ apps" NUMBER, "total\ goals" NUMBER, "notes" CLOB)

what year is at the very top ?
SELECT "year" FROM table_204_27 WHERE id = 1
SELECT "year" FROM "table_204_27" WHERE "id" = 1