Table: golf_asian_games_medals
Columns: year
location
gold
silver
bronze

Question: What is the most recent year that China won a bronze?
SQL: SELECT MAX("year") FROM golf_asian_games_medals WHERE "bronze" = 'china'

Question: What is the oldest year that the location was at Guangzhou?
SQL: SELECT MIN("year") FROM golf_asian_games_medals WHERE "location" = 'guangzhou'

Question: For how many years was the location at Beijing?
SQL: SELECT SUM("year") FROM golf_asian_games_medals WHERE "location" = 'beijing'

Question: What location is previous to 1994?
SQL: SELECT "location" FROM golf_asian_games_medals WHERE "year" < 1994