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 ¶"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: 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? [/INST] SELECT artist FROM table_name_28 WHERE weeks_on_top = "9 ¶" </s>