CREATE TABLE table_name_32 (team VARCHAR, player VARCHAR)

WHAT IS THE TEAM WITH DAVE COGGIN?
SELECT team FROM table_name_32 WHERE player = "dave coggin"
SELECT "team" FROM "table_name_32" WHERE "dave coggin" = "player"