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

What college did Calvin McCarty play at?
SELECT "College" FROM table_100 WHERE "Player" = 'Calvin McCarty'
SELECT "College" FROM "table_100" WHERE "Player" = 'Calvin McCarty'