Table schema:
CREATE TABLE table_name_42 (player_name VARCHAR, position VARCHAR, year VARCHAR)

Question: What is the name of the cornerback from 1997?
SQL: SELECT player_name FROM table_name_42 WHERE position = "cornerback" AND year = 1997