user: ### NOW ANSWER:
Question: Who did the housemate that nominated Carol Roopali in week 1 nominate in week 8?
Columns: ['Week 1', 'Week 3', 'Week 4', 'Week 6', 'Week 7', 'Week 8', 'Week 9', 'Week 10', 'Final Week 12']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Amit Bobby', 'Kashmera Rakhi', 'Rakhi Roopali', 'Deepak T Ragini', 'Deepak T Roopali', 'Amit Roopali', 'Amit Baba', 'Rakhi Roopali', 'Winner']
SQL:

assistant: SELECT "Week 8" FROM "Table" WHERE "Week 1" = 'Carol Roopali';