Table: pan_games_medals
Columns: rank
nation
gold
silver
bronze
total

Question: What nation had more than 97 Gold Medals and fewer than 332 Silver Medals?
SQL: SELECT SUM("total") FROM pan_games_medals WHERE "gold" > 97 AND "silver" < 332

Question: What nation had 135 Bronze medals?
SQL: SELECT COUNT("bronze") FROM pan_games_medals WHERE "total" = 135