CREATE TABLE table_26962 ("Name" CLOB, "Position" CLOB, "Period" CLOB, "Appearances\\u00b9" FLOAT, "Goals\\u00b9" FLOAT, "Nationality\\u00b2" CLOB)

What is the highest number of goals scored
SELECT MAX("Goals\u00b9") FROM table_26962
SELECT MAX("Goals\u00b9") FROM "table_26962"