Table: figure_skating_championships_1999
Columns: rank
nation
gold
silver
bronze
total

Question: What is the highest total when bronze is less than 1 and gold more than 0?
SQL: SELECT MAX("total") FROM figure_skating_championships_1999 WHERE "bronze" < 1 AND "gold" > 0

Question: what is the sum of bronze when the rank is 5, the nation is poland and gold is less than 0?
SQL: SELECT SUM("bronze") FROM figure_skating_championships_1999 WHERE "rank" = 5 AND "nation" = 'poland' AND "gold" < 0

Question: what is the sum of silver when the rank is 3, nation is france and bronze is less than 0?
SQL: SELECT SUM("silver") FROM figure_skating_championships_1999 WHERE "rank" = 3 AND "nation" = 'france' AND "bronze" < 0

Question: How many times is the nation china and bronze more than 0?
SQL: SELECT COUNT("rank") FROM figure_skating_championships_1999 WHERE "nation" = 'china' AND "bronze" > 0

Question: How many times is the rank higher than 3 and bronze more than 1?
SQL: SELECT COUNT("gold") FROM figure_skating_championships_1999 WHERE "rank" > 3 AND "bronze" > 1

Question: what is the least silver when bronze is 1, rank is less than 2 and gold is more than 4?
SQL: SELECT MIN("silver") FROM figure_skating_championships_1999 WHERE "bronze" = 1 AND "rank" < 2 AND "gold" > 4