CREATE TABLE table_9849 ("Volume:Issue" CLOB, "Issue Date ( s ) " CLOB, "Weeks on Top" CLOB, "Song" CLOB, "Artist" CLOB)

Who was the artist of the single that spent 9 weeks on top?
SELECT "Artist" FROM table_9849 WHERE "Weeks on Top" = '9 ¶'
SELECT "Artist" FROM "table_9849" WHERE "Weeks on Top" = '9 ¶'