what is the average bronze when the team is northwest territories and gold is more than 34?
CREATE TABLE table_8243 (
    "Team" text,
    "Gold" real,
    "Silver" real,
    "Bronze" real,
    "Overall" real
)
SELECT AVG("Bronze") FROM table_8243 WHERE "Team" = 'northwest territories' AND "Gold" > '34'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: what is the average bronze when the team is northwest territories and gold is more than 34? ### Input: CREATE TABLE table_8243 (
    "Team" text,
    "Gold" real,
    "Silver" real,
    "Bronze" real,
    "Overall" real
) ### Response: SELECT AVG("Bronze") FROM table_8243 WHERE "Team" = 'northwest territories' AND "Gold" > '34'