What was the week 2 prior to the when Miranda Jordan was the week 4?
CREATE TABLE table_name_99 (week_2 VARCHAR, week_4 VARCHAR)
SELECT week_2 FROM table_name_99 WHERE week_4 = "miranda jordan"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_99 (week_2 VARCHAR, week_4 VARCHAR) Question: What was the week 2 prior to the when Miranda Jordan was the week 4? [/INST] SELECT week_2 FROM table_name_99 WHERE week_4 = "miranda jordan" </s>