CREATE TABLE table_28091 ("Entered [A ]" CLOB, "Weeks in top 10" FLOAT, "Single" CLOB, "Artist" CLOB, "Peak" FLOAT, "Peak reached [A ]" CLOB, "Weeks at number 1" FLOAT)

error (see notes)
SELECT MIN("Weeks at number 1") FROM table_28091
SELECT MIN("Weeks at number 1") FROM "table_28091"