Table: olympic_medals
Columns: athlete
sport
type
olympics
gold
silver
bronze
total

Question: What is the average gold of the winter athlete with 1 bronze, less than 3 silver, and less than 4 total medals?
SQL: SELECT AVG("gold") FROM olympic_medals WHERE "bronze" = 1 AND "type" = 'winter' AND "silver" < 3 AND "total" < 4

Question: What is the highest total medals winter athlete Clara Hughes has?
SQL: SELECT MAX("total") FROM olympic_medals WHERE "type" = 'winter' AND "athlete" = 'clara hughes'

Question: What is the lowest number of bronze a short track athlete with 0 gold medals has?
SQL: SELECT MIN("bronze") FROM olympic_medals WHERE "sport" = 'short track' AND "gold" = 0