Table: pan_am_basketball_medals
Columns: rank
gold
silver
bronze
total

Question: Which average bronze had a silver greater than 2 and a gold larger than 7?
SQL: SELECT AVG("bronze") FROM pan_am_basketball_medals WHERE "silver" > 2 AND "gold" > 7

Question: When the total was 11 and silver was greater than 4 what was the highest gold?
SQL: SELECT MAX("gold") FROM pan_am_basketball_medals WHERE "total" = 11 AND "silver" > 4

Question: How many bronze had a total less than 4 and gold bigger than 1?
SQL: SELECT COUNT("bronze") FROM pan_am_basketball_medals WHERE "total" < 4 AND "gold" > 1