Table: high_school_hockey
Columns: school
nickname
colors
league
class
division

Question: What is the nickname of the team that has the colors blue and gold?
SQL: SELECT "nickname" FROM high_school_hockey WHERE "colors" = 'blue and gold'

Question: What is the nickname of the team that has the colors black and gold?
SQL: SELECT "nickname" FROM high_school_hockey WHERE "colors" = 'black and gold'

Question: What is the nickname of the team in division 2?
SQL: SELECT "nickname" FROM high_school_hockey WHERE "division" = 'division 2'

Question: What is the class of the Middletown High School team that is in the DSHA league?
SQL: SELECT "class" FROM high_school_hockey WHERE "league" = 'dsha' AND "school" = 'middletown high school'

Question: What school is the team from that has the colors blue and gold?
SQL: SELECT "school" FROM high_school_hockey WHERE "colors" = 'blue and gold'

Question: What are the colors for the division 2 team with the nickname, the seahawks?
SQL: SELECT "colors" FROM high_school_hockey WHERE "division" = 'division 2' AND "nickname" = 'seahawks'