Table: olympic_medals_2
Columns: rank
nation
gold
silver
bronze
total

Question: The United States, with a total medal count of less than 171, and a bronze medal count less than 9, has how many gold medals?
SQL: SELECT MAX("gold") FROM olympic_medals_2 WHERE "total" < 171 AND "nation" = 'united states' AND "bronze" < 9

Question: How many total gold medals did Australia receive?
SQL: SELECT COUNT("gold") FROM olympic_medals_2 WHERE "nation" = 'australia'

Question: How many total bronze medals did Canada receive?
SQL: SELECT MAX("bronze") FROM olympic_medals_2 WHERE "nation" = 'canada'

Question: How many total gold medals did India receive?
SQL: SELECT "gold" FROM olympic_medals_2 WHERE "nation" = 'india'