SCHEMA:
CREATE TABLE table_name_42 (player_name VARCHAR, position VARCHAR, year VARCHAR)
USER:
What is the name of the cornerback from 1997?

QUERY:
SELECT player_name FROM table_name_42 WHERE position = "cornerback" AND year = 1997