CREATE TABLE table_name_97 (player VARCHAR, college VARCHAR)

Which player is from the College of Alabama?
SELECT player FROM table_name_97 WHERE college = "alabama"
SELECT "player" FROM "table_name_97" WHERE "alabama" = "college"