CREATE TABLE table_name_99 (week_2 VARCHAR2, week_4 VARCHAR2)

What was the week 2 prior to the when Miranda Jordan was the week 4?
SELECT week_2 FROM table_name_99 WHERE week_4 = "miranda jordan"
SELECT "week_2" FROM "table_name_99" WHERE "miranda jordan" = "week_4"