Table: oceania_championship_women
Columns: rank
gold
silver
bronze
total

Question: Name the average total for gold less than 1 and rank less than 5
SQL: SELECT AVG("total") FROM oceania_championship_women WHERE "gold" < 1 AND "rank" < 5

Question: Name the sum of silver when total is mor ethan 1, bronze is 1 and gold is les than 0
SQL: SELECT SUM("silver") FROM oceania_championship_women WHERE "total" > 1 AND "bronze" = 1 AND "gold" < 0

Question: Name the most gold when bronze is more than 0 and rank is more than 5 with total more than 2
SQL: SELECT MAX("gold") FROM oceania_championship_women WHERE "bronze" > 0 AND "rank" > 5 AND "total" > 2

Question: Name the average bronze with silver more than 0, total of 6 and gold more than 0
SQL: SELECT AVG("bronze") FROM oceania_championship_women WHERE "silver" > 0 AND "total" = 6 AND "gold" > 0

Question: Name the sum of total with gold more than 1 and bronze more than 0
SQL: SELECT SUM("total") FROM oceania_championship_women WHERE "gold" > 1 AND "bronze" > 0