CREATE TABLE table_name_7 (club_team VARCHAR, player VARCHAR, position VARCHAR, nationality VARCHAR)

Which Club Team has a Position of (d), a Nationality of canada, and a Player of andrew macwilliam?
SELECT club_team FROM table_name_7 WHERE position = "(d)" AND nationality = "canada" AND player = "andrew macwilliam"
SELECT "club_team" FROM "table_name_7" WHERE "(d)" = "position" AND "andrew macwilliam" = "player" AND "canada" = "nationality"