Table: games_medals
Columns: rank
gold
silver
bronze
total

Question: What is the average Silver with rank 30 and a Bronze greater than 0
SQL: SELECT AVG("silver") FROM games_medals WHERE "rank" = '30' AND "bronze" > 0

Question: What is the highest Gold that has a Silver less than 7 and Bronze less than 0
SQL: SELECT MAX("gold") FROM games_medals WHERE "silver" < 7 AND "bronze" < 0

Question: What is the highest Bronze with a Silver greater than 0 and a Gold of 7 and a total less than 29
SQL: SELECT MAX("bronze") FROM games_medals WHERE "silver" > 0 AND "gold" = 7 AND "total" < 29

Question: What is the sum of Total ranking 9 and a Gold more than 6
SQL: SELECT SUM("total") FROM games_medals WHERE "rank" = '9' AND "gold" > 6

Question: What is the lowest Bronze with a 17 Rank and a Total less than 5
SQL: SELECT MIN("bronze") FROM games_medals WHERE "rank" = '17' AND "total" < 5