What is the BBC 2 rank when BBC 1 is 1st rank and the total viewing is 9,840,000?
CREATE TABLE table_name_2 (bbc_two_rank VARCHAR, bbc_one_rank VARCHAR, bbc_one_total_viewing VARCHAR)
SELECT bbc_two_rank FROM table_name_2 WHERE bbc_one_rank = "1st" AND bbc_one_total_viewing = "9,840,000"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_2 (bbc_two_rank VARCHAR, bbc_one_rank VARCHAR, bbc_one_total_viewing VARCHAR) Question: What is the BBC 2 rank when BBC 1 is 1st rank and the total viewing is 9,840,000? [/INST] SELECT bbc_two_rank FROM table_name_2 WHERE bbc_one_rank = "1st" AND bbc_one_total_viewing = "9,840,000" </s>