Table: iran_asian_games_medals
Columns: games
gold
silver
bronze
total
rank

Question: What is the rank of the games that had 9 gold and 9 silvers?
SQL: SELECT "rank" FROM iran_asian_games_medals WHERE "gold" = '9' AND "silver" = '9'

Question: How many golds were there in a game that has 17 bronze and a total of 31?
SQL: SELECT "gold" FROM iran_asian_games_medals WHERE "bronze" = '17' AND "total" = '31'

Question: Which game had 8 bronze and 4 gold?
SQL: SELECT "games" FROM iran_asian_games_medals WHERE "bronze" = '8' AND "gold" = '4'