Table: tribal_council
Columns: air_date
reward
immunity
eliminated
vote
finish

Question: What was the vote when the air date is 4 october 1997?
SQL: SELECT "vote" FROM tribal_council WHERE "air_date" = '4 October 1997'

Question: Who was eliminated when immunity went to kent (jürgen)?
SQL: SELECT "eliminated" FROM tribal_council WHERE "immunity" = 'Kent (Jürgen)'

Question: Who was eliminated when the vote was 8-1?
SQL: SELECT "eliminated" FROM tribal_council WHERE "vote" = '8-1'

Question: How many entries are there for vote when the air date was 15 november 1997?
SQL: SELECT COUNT("vote") FROM tribal_council WHERE "air_date" = '15 November 1997'

Question: What was the  reward  when immunity went to martin and finish is 13th voted out 8th jury member day 46?
SQL: SELECT "reward" FROM tribal_council WHERE "immunity" = 'Martin' AND "finish" = '13th Voted Out 8th Jury Member Day 46'