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