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

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'