Table schema:
CREATE TABLE table_name_54 (nickname VARCHAR, location VARCHAR)

Question: What is the nickname of the school located in Manchester, New Hampshire?
SQL: SELECT nickname FROM table_name_54 WHERE location = "manchester, new hampshire"