Table schema:
CREATE TABLE table_name_34 (nickname VARCHAR, division VARCHAR)

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