Table: medal_counts_1930_british
Columns: rank
gold
silver
bronze
total

Question: What is the fewest bronze medals when the total medals is less than 10, and the gold medals less than 0?
SQL: SELECT MIN("bronze") FROM medal_counts_1930_british WHERE "total" < 10 AND "gold" < 0

Question: With 8 as the rank, and a total of more than 2 medals what is the average bronze medals?
SQL: SELECT AVG("bronze") FROM medal_counts_1930_british WHERE "rank" = '8' AND "total" > 2

Question: What is the maximum total medals when the rank is 8?
SQL: SELECT MAX("total") FROM medal_counts_1930_british WHERE "rank" = '8'

Question: What is the largest number of gold medals when the bronze medals is less than 49, and there is 22 silver medals, and the total is less than 60?
SQL: SELECT MAX("gold") FROM medal_counts_1930_british WHERE "bronze" < 49 AND "silver" = 22 AND "total" < 60

Question: When the number of gold medals is greater than 59, and the rank is total, what is the average bronze medals?
SQL: SELECT AVG("bronze") FROM medal_counts_1930_british WHERE "rank" = 'total' AND "gold" > 59