Table: equestrian_asian_games_medals
Columns: year
location
gold
silver
bronze

Question: In what year(s) did South Korea win silver?
SQL: SELECT "year" FROM equestrian_asian_games_medals WHERE "silver" = 'south korea'

Question: Which nation(s) won silver in Doha?
SQL: SELECT "silver" FROM equestrian_asian_games_medals WHERE "location" = 'doha'

Question: What was the first year that South Korea won gold and Malaysia won bronze?
SQL: SELECT MIN("year") FROM equestrian_asian_games_medals WHERE "gold" = 'south korea' AND "bronze" = 'malaysia'

Question: What country won gold in the year(s) that Chinese Taipei won bronze?
SQL: SELECT "gold" FROM equestrian_asian_games_medals WHERE "bronze" = 'chinese taipei'