Table schema:
CREATE TABLE table_name_24 (pick VARCHAR, year VARCHAR)

Question: What was the pick in 2004?
SQL: SELECT pick FROM table_name_24 WHERE year = 2004