question: What is the nickname of the school located in Manchester, New Hampshire?
answer: SELECT nickname FROM table_name_54 WHERE location = "manchester, new hampshire"
context: CREATE TABLE table_name_54 (nickname VARCHAR, location VARCHAR)