CREATE TABLE table_203_197 (id NUMBER, "#" NUMBER, "title" CLOB, "artist" CLOB, "highest pos. reached" NUMBER, "weeks at no. 1" CLOB)

who had the most weeks at number one , according to the table ?
SELECT "artist" FROM table_203_197 ORDER BY "weeks at no. 1" DESC LIMIT 1
SELECT "artist" FROM "table_203_197" ORDER BY "weeks at no. 1" DESC FETCH FIRST 1 ROWS ONLY