Table: t_1935_cac_games_medals
Columns: rank
nation
gold
silver
bronze
total

Question: How many Silver medals did nation who is ranked greater than 1 and has 4 Gold medals have?
SQL: SELECT SUM("silver") FROM t_1935_cac_games_medals WHERE "rank" > 1 AND "gold" = 4

Question: Which nation has more than 6 Silver medals and fewer than 8 Gold medals?
SQL: SELECT AVG("total") FROM t_1935_cac_games_medals WHERE "silver" > 6 AND "gold" < 8

Question: What is the rank of the Nation that has fewer than 24 total medals are more than 7 Gold medals?
SQL: SELECT AVG("rank") FROM t_1935_cac_games_medals WHERE "total" < 24 AND "gold" > 7

Question: What is the rank of the nation that has more than 1 Bronze medals and fewer than 4 Gold medals?
SQL: SELECT MIN("rank") FROM t_1935_cac_games_medals WHERE "bronze" > 1 AND "gold" < 4