Table: cfl_draft_1998_3
Columns: pick
cfl_team
player
position
college

Question: How many times is the player scott deibert?
SQL: SELECT COUNT("pick") FROM cfl_draft_1998_3 WHERE "player" = 'scott deibert'

Question: what is the pick # for william loftus?
SQL: SELECT "pick" FROM cfl_draft_1998_3 WHERE "player" = 'william loftus'

Question: what is the cfl team for position d?
SQL: SELECT "cfl_team" FROM cfl_draft_1998_3 WHERE "position" = 'd'