CREATE TABLE table_name_40 (player VARCHAR2, college VARCHAR2)

What p;layer attended Concordia College?
SELECT player FROM table_name_40 WHERE college = "concordia"
SELECT "player" FROM "table_name_40" WHERE "college" = "concordia"