CREATE TABLE table_30001 ("Entry Date [A ]" CLOB, "Single" CLOB, "Artist" CLOB, "Peak" FLOAT, "Peak Reached [A ]" CLOB, "Weeks in top 10" FLOAT)

How long has the longest song spent in the top 10?
SELECT MAX("Weeks in top 10") FROM table_30001
SELECT MAX("Weeks in top 10") FROM "table_30001"