CREATE TABLE table_name_28 (artist VARCHAR(255), weeks_on_top VARCHAR(255))
Who was the artist of the single that spent 9 ¶ weeks on top?
    
SQL: SELECT artist FROM table_name_28 WHERE weeks_on_top = "9 ¶"