human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Games, First, Last, Gold, Bronze, Total, Best finish (first/last)
###Question: How many bronzes associated with over 0 total medals, 3 golds, and over 6 games?
gpt
SELECT AVG Bronze FROM table WHERE Total > 0 AND Gold = 3 AND Games > 6