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

How many times is the player scott deibert?
SELECT COUNT("Pick #") FROM table_49150 WHERE "Player" = 'scott deibert'
SELECT COUNT("Pick #") FROM "table_49150" WHERE "Player" = 'scott deibert'