Table: paralympic_table_tennis_2004
Columns: rank
nation
gold
silver
bronze
total

Question: What is the sum of all totals with a rank greater than 6, gold greater than 0, and silver greater than 2?
SQL: SELECT SUM("total") FROM paralympic_table_tennis_2004 WHERE "rank" > 6 AND "gold" > 0 AND "silver" = 2

Question: How many values for silver occur when gold is less than 1, the rank is 13, and bronze is greater than 2?
SQL: SELECT COUNT("silver") FROM paralympic_table_tennis_2004 WHERE "gold" < 1 AND "rank" = 13 AND "bronze" > 2

Question: What is the average value of Bronze when silver is 0 and the total is less than 1?
SQL: SELECT AVG("bronze") FROM paralympic_table_tennis_2004 WHERE "silver" = 0 AND "total" < 1

Question: What is the lowest value for bronze with a total of 3 and a value for silver greater than 1 while the value of gold is smaller than 1?
SQL: SELECT MIN("bronze") FROM paralympic_table_tennis_2004 WHERE "total" = 3 AND "silver" > 1 AND "gold" < 1

Question: How man values for bronze occur when gold is less than 1, rank is greater than 15, and total is greater than 1?
SQL: SELECT COUNT("bronze") FROM paralympic_table_tennis_2004 WHERE "gold" < 1 AND "rank" > 15 AND "total" > 1