What is the title of every song, and how many weeks was each song at #1 for Rihanna in 2012?
CREATE TABLE table_19542477_9 (song_s__—_weeks VARCHAR, issue_years VARCHAR, artist_s_ VARCHAR)
SELECT song_s__—_weeks FROM table_19542477_9 WHERE issue_years = 2012 AND artist_s_ = "Rihanna"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_19542477_9 (song_s__—_weeks VARCHAR, issue_years VARCHAR, artist_s_ VARCHAR) Question: What is the title of every song, and how many weeks was each song at #1 for Rihanna in 2012? [/INST] SELECT song_s__—_weeks FROM table_19542477_9 WHERE issue_years = 2012 AND artist_s_ = "Rihanna" </s>