CREATE TABLE table_name_94 (player VARCHAR, school VARCHAR)

Which player attended Hoover High School?
SELECT player FROM table_name_94 WHERE school = "hoover high school"
SELECT "player" FROM "table_name_94" WHERE "hoover high school" = "school"