user: ### NOW ANSWER:
Question: What was the week 2 prior to the when Miranda Jordan was the week 4?
Columns: ['Week 1', 'Week 2', 'Week 3', 'Week 4', 'Week 5']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Stacy Marie', 'Kaya Danielle*', 'Tawny Taylor', 'Samantha Pirie', 'Madelon Jeanne Cullen']
SQL:

assistant: SELECT "Week 2" FROM "Table" WHERE "Week 4" = 'Miranda Jordan';