Table: womens_u18_iihf
Columns: games
first
last
gold
bronze
total
best_finish_first_last

Question: What is the latest first year with 0 total medals and over 0 golds?
SQL: SELECT MAX("first") FROM womens_u18_iihf WHERE "total" > 0 AND "gold" > 0

Question: How many bronzes associated with over 0 total medals, 3 golds, and over 6 games?
SQL: SELECT AVG("bronze") FROM womens_u18_iihf WHERE "total" > 0 AND "gold" = 3 AND "games" > 6

Question: What is the fewest number of medals associated with under 6 games and over 0 golds?
SQL: SELECT MIN("total") FROM womens_u18_iihf WHERE "games" < 6 AND "gold" > 0

Question: How many games are associated with over 0 golds and a first year before 2008?
SQL: SELECT SUM("games") FROM womens_u18_iihf WHERE "gold" > 0 AND "first" < 2008