Table: euro_86_medals
Columns: rank
nation
gold
silver
bronze
total

Question: What is the total number of bronzes that is less than 1 in total?
SQL: SELECT COUNT("bronze") FROM euro_86_medals WHERE "total" < 1

Question: What is the total number of bronze that has less than 2 gold, and more than 1 silver?
SQL: SELECT COUNT("bronze") FROM euro_86_medals WHERE "gold" < 2 AND "silver" > 1

Question: What is the lowest rank with less than 1 gold, 0 silver, 1 bronze, and a total less than 1?
SQL: SELECT MIN("rank") FROM euro_86_medals WHERE "gold" < 1 AND "silver" = 0 AND "bronze" = 1 AND "total" < 1

Question: What is the average bronze for less than 0 gold?
SQL: SELECT AVG("bronze") FROM euro_86_medals WHERE "gold" < 0

Question: What is the total number for less than 8 bronze, the Netherlands nation, and is ranked less than 16?
SQL: SELECT COUNT("total") FROM euro_86_medals WHERE "bronze" < 8 AND "nation" = 'netherlands' AND "rank" < 16