CREATE TABLE table_name_34 (nickname VARCHAR, division VARCHAR)

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