CREATE TABLE table_76786 ("Pick #" FLOAT, "CFL Team" CLOB, "Player" CLOB, "Position" CLOB, "College" CLOB)

Which Pick # has a College of concordia?
SELECT MAX("Pick #") FROM table_76786 WHERE "College" = 'concordia'
SELECT MAX("Pick #") FROM "table_76786" WHERE "College" = 'concordia'