Table: golf_asian_games_results
Columns: year
location
gold
silver
bronze

Question: Who won the gold medal in 1998?
SQL: SELECT "gold" FROM golf_asian_games_results WHERE "year" = 1998

Question: What is the total number of years when Mika Miyazato won the silver?
SQL: SELECT COUNT("year") FROM golf_asian_games_results WHERE "silver" = 'mika miyazato'

Question: What is the location of the Asian Games after 2002 when Kim Hyun-soo won the gold?
SQL: SELECT "location" FROM golf_asian_games_results WHERE "year" > 2002 AND "gold" = 'kim hyun-soo'

Question: What is the earliest year that kim hyun-soo won the gold?
SQL: SELECT MIN("year") FROM golf_asian_games_results WHERE "gold" = 'kim hyun-soo'