Table: kids_quiz_teams
Columns: episode
air_date
team_swash
team_guest_captain
team_coxy

Question: What was the air date when the team guest captain was john bishop?
SQL: SELECT "air_date" FROM kids_quiz_teams WHERE "team_guest_captain" = 'John Bishop'

Question: Who was the team guest captain for episode 2?
SQL: SELECT "team_guest_captain" FROM kids_quiz_teams WHERE "episode" = 2

Question: Who was the team swash when the team guest captain was gail porter?
SQL: SELECT "team_swash" FROM kids_quiz_teams WHERE "team_guest_captain" = 'Gail Porter'

Question: How many entries are there for team coxy for the air date of 24 january 2010 and team guest captain of gail porter?
SQL: SELECT COUNT("team_coxy") FROM kids_quiz_teams WHERE "air_date" = '24 January 2010' AND "team_guest_captain" = 'Gail Porter'

Question: How many entries are shown for an air date when the team guest captain was stephen k amos?
SQL: SELECT COUNT("air_date") FROM kids_quiz_teams WHERE "team_guest_captain" = 'Stephen K Amos'