CREATE TABLE table_name_54 (nickname VARCHAR, location VARCHAR)

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