Schema: CREATE TABLE table_name_23 (bronze INTEGER, team VARCHAR, gold VARCHAR)
Question: what is the average bronze when the team is northwest territories and gold is more than 34?
SQL: SELECT AVG(bronze) FROM table_name_23 WHERE team = "northwest territories" AND gold > 34