Table: euro_olympic_qual
Columns: rank
nation
gold
silver
bronze
total

Question: What's the total of Sweden (SWE) having less than 1 silver?
SQL: SELECT MIN("total") FROM euro_olympic_qual WHERE "nation" = 'sweden (swe)' AND "silver" < 1

Question: What's the total number of bronze medals for Sweden (SWE) having less than 1 gold and silver?
SQL: SELECT COUNT("bronze") FROM euro_olympic_qual WHERE "gold" < 1 AND "nation" = 'sweden (swe)' AND "silver" < 1

Question: What's the total when the gold is less than 0 and silver is less than 1?
SQL: SELECT AVG("total") FROM euro_olympic_qual WHERE "silver" = 1 AND "gold" < 0

Question: What's the total of rank 8 when Silver medals are 0 and gold is more than 1?
SQL: SELECT COUNT("total") FROM euro_olympic_qual WHERE "silver" = 0 AND "rank" = 8 AND "gold" > 1

Question: What are the most bronze medals in a rank more than 1 with a total larger than 3?
SQL: SELECT MAX("bronze") FROM euro_olympic_qual WHERE "total" > 3 AND "rank" > 1

Question: What's the rank of Turkey (TUR) with a total more than 2?
SQL: SELECT COUNT("rank") FROM euro_olympic_qual WHERE "nation" = 'turkey (tur)' AND "total" > 2