Table: secret_story_2_france
Columns: week_1
week_2
week_3
week_4
week_5
week_6
week_7
week_8
week_9
week_10_final

Question: What kind of Week 4  has a Week 9 of all housemates?
SQL: SELECT "week_4" FROM secret_story_2_france WHERE "week_9" = 'all housemates'

Question: Which Week 3 has a Week 9 of ejected (day 3)?
SQL: SELECT "week_3" FROM secret_story_2_france WHERE "week_9" = 'ejected (day 3)'

Question: What kind of Week 1 has a Week 8 of not eligible, and a Week 9 of no nominations, and a Week 3 of cyril? Question 3
SQL: SELECT "week_1" FROM secret_story_2_france WHERE "week_8" = 'not eligible' AND "week_9" = 'no nominations' AND "week_3" = 'cyril'

Question: What kind of Week 9 has a Week 1 of no nominations, and a Week 6 of not eligible, and a Week 2 of not eligible, and a Week 10 FINAL of evicted (day 57)?
SQL: SELECT "week_9" FROM secret_story_2_france WHERE "week_1" = 'no nominations' AND "week_6" = 'not eligible' AND "week_2" = 'not eligible' AND "week_10_final" = 'evicted (day 57)'

Question: What kind of Week 7 has a Week 5 of evicted (day 15)?
SQL: SELECT "week_7" FROM secret_story_2_france WHERE "week_5" = 'evicted (day 15)'

Question: What kind of Week 6 has a Week 2 of see notes 2 , 3 , 4?
SQL: SELECT "week_6" FROM secret_story_2_france WHERE "week_2" = 'see notes 2 , 3 , 4'