Table: volleyball_2006_asian_games
Columns: rank
nation
gold
silver
bronze
total

Question: What average bronze has a total less than 1?
SQL: SELECT AVG("bronze") FROM volleyball_2006_asian_games WHERE "total" < 1

Question: What average gold has China (chn) as the nation with a bronze greater than 1?
SQL: SELECT AVG("gold") FROM volleyball_2006_asian_games WHERE "nation" = 'china (chn)' AND "bronze" > 1

Question: Which is the highest gold that has a bronze greater than 4?
SQL: SELECT MAX("gold") FROM volleyball_2006_asian_games WHERE "bronze" > 4