Table: olympic_medals_1998
Columns: rank
nation
gold
silver
bronze
total

Question: What is the sum of gold medals for the United States with silver medal count greater than 3?
SQL: SELECT SUM("gold") FROM olympic_medals_1998 WHERE "nation" = 'united states' AND "silver" > 3

Question: What is the total number of medals of Norway with a silver medal count greater than 6 and a gold medal count greater than 10?
SQL: SELECT COUNT("total") FROM olympic_medals_1998 WHERE "silver" > 6 AND "nation" = 'norway' AND "gold" > 10

Question: What is the lowest bronze medal count for Italy with fewer than 6 gold medals and greater than 10 total medals?
SQL: SELECT MIN("bronze") FROM olympic_medals_1998 WHERE "gold" < 6 AND "nation" = 'italy' AND "total" > 10

Question: On average, what is the number of silver medals for nations ranking higher than 7, with a total of 6 medals and fewer than 2 bronze medals?
SQL: SELECT AVG("silver") FROM olympic_medals_1998 WHERE "rank" > 7 AND "total" = 6 AND "bronze" < 2

Question: For the United States, with greater than 2 bronze metals, greater than 3 silver medals, and a rank higher than 3, what is the highest total number of medals?
SQL: SELECT MAX("total") FROM olympic_medals_1998 WHERE "bronze" > 2 AND "rank" > 3 AND "nation" = 'united states' AND "silver" > 3