CREATE TABLE table_name_94 (round VARCHAR, position VARCHAR, player VARCHAR)

What is the total number of Round, when Position is 'D', and when Player is 'Andrew Campbell'?
SELECT COUNT(round) FROM table_name_94 WHERE position = "d" AND player = "andrew campbell"
SELECT COUNT("round") FROM "table_name_94" WHERE "andrew campbell" = "player" AND "d" = "position"