question: What college did the player with a school of huntsville high school go to?
answer: SELECT college FROM table_name_42 WHERE school = "huntsville high school"
context: CREATE TABLE table_name_42 (college VARCHAR, school VARCHAR)