Table: women_islamic_games_medals
Columns: rank
gold
silver
bronze
total

Question: What is the number of bronze medals when the total medals were 78 and there were less than 12 golds?
SQL: SELECT SUM("bronze") FROM women_islamic_games_medals WHERE "total" = 78 AND "gold" < 12

Question: What is the average number of gold medals when the total was 1335 medals, with more than 469 bronzes and more than 14 silvers?
SQL: SELECT AVG("gold") FROM women_islamic_games_medals WHERE "silver" > 14 AND "total" = 1335 AND "bronze" > 469

Question: What is the total amount of gold medals when there were more than 20 silvers and there were 135 bronze medals?
SQL: SELECT COUNT("gold") FROM women_islamic_games_medals WHERE "silver" > 20 AND "bronze" = 135