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

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