human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Rank, Nation, Gold, Silver, Bronze, Total
###Question: What is the average Bronze for rank 3 and total is more than 8?
gpt
SELECT AVG Bronze FROM table WHERE Rank = 3 AND Total > 8