CREATE TABLE table_40001 ("Round" FLOAT, "Overall" FLOAT, "Player" CLOB, "Position" CLOB, "College" CLOB)

What is the Player from appalachian state?
SELECT "Player" FROM table_40001 WHERE "College" = 'appalachian state'
SELECT "Player" FROM "table_40001" WHERE "College" = 'appalachian state'