CREATE TABLE table_name_28 (artist VARCHAR, weeks_on_top VARCHAR)

Who was the artist of the single that spent 9 weeks on top?
SELECT artist FROM table_name_28 WHERE weeks_on_top = "9 ¶"
SELECT "artist" FROM "table_name_28" WHERE "9 ¶" = "weeks_on_top"