CREATE TABLE table_name_42 (college VARCHAR, school VARCHAR)

What college did the player with a school of huntsville high school go to?
SELECT college FROM table_name_42 WHERE school = "huntsville high school"
SELECT "college" FROM "table_name_42" WHERE "huntsville high school" = "school"