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