Table: badminton_pan_am_games
Columns: rank
nation
gold
silver
bronze
total

Question: Tell me the total number of gold for bronze more than 0 and total more than 100
SQL: SELECT COUNT("gold") FROM badminton_pan_am_games WHERE "bronze" > 0 AND "rank" = 'total' AND "total" > 100

Question: Tell me the least silver for total less than 6 and rank of 8
SQL: SELECT MIN("silver") FROM badminton_pan_am_games WHERE "total" < 6 AND "rank" = '8'