CREATE TABLE table_3042 ("Episode no." FLOAT, "Airdate" CLOB, "Viewers" FLOAT, "BBC Three weekly ranking" FLOAT, "Cable rank" FLOAT)

What is the highest cable ranking?
SELECT MAX("Cable rank") FROM table_3042
SELECT MAX("Cable rank") FROM "table_3042"