Table: black_diamond_conference_teams
Columns: team_name
schools
sports
host
nickname_s
colors
enrollment_2013_14

Question: What is the name of the team from cisne fairfield school?
SQL: SELECT "team_name" FROM black_diamond_conference_teams WHERE "schools" = 'cisne fairfield'

Question: What is the name of the team from goreville vienna school?
SQL: SELECT "team_name" FROM black_diamond_conference_teams WHERE "schools" = 'goreville vienna'

Question: What are the colors of the team hosted by Christopher?
SQL: SELECT "colors" FROM black_diamond_conference_teams WHERE "host" = 'christopher'