CREATE TABLE table_8243 ("Team" TEXT, "Gold" FLOAT, "Silver" FLOAT, "Bronze" FLOAT, "Overall" FLOAT)

what is the average bronze when the team is northwest territories and gold is more than 34?
SELECT AVG("Bronze") FROM table_8243 WHERE "Team" = 'northwest territories' AND "Gold" > '34'
SELECT AVG("Bronze") FROM "table_8243" WHERE "Gold" > '34' AND "Team" = 'northwest territories'