Table: olympic_art_1928
Columns: rank
nation
gold
silver
bronze
total

Question: What is the sum of Bronze, when Gold is less than 1, when Total is greater than 1, and when Rank is 10?
SQL: SELECT SUM("bronze") FROM olympic_art_1928 WHERE "gold" < 1 AND "total" > 1 AND "rank" = 10

Question: What is the average Bronze, when Rank is greater than 6, when Nation is Italy (ITA), and when Total is less than 1?
SQL: SELECT AVG("bronze") FROM olympic_art_1928 WHERE "rank" > 6 AND "nation" = 'italy (ita)' AND "total" < 1

Question: What is the sum of Total, when Silver is greater than 1, when Rank is 9, and when Bronze is greater than 0?
SQL: SELECT SUM("total") FROM olympic_art_1928 WHERE "silver" > 1 AND "rank" = 9 AND "bronze" > 0

Question: What is the average Gold, when Total is 2, when Silver is less than 1, and when Rank is greater than 5?
SQL: SELECT AVG("gold") FROM olympic_art_1928 WHERE "total" = 2 AND "silver" < 1 AND "rank" > 5

Question: What is the sum of Rank, when Bronze is less than 1, when Nation is Switzerland (SUI), and when Total is less than 2?
SQL: SELECT SUM("rank") FROM olympic_art_1928 WHERE "bronze" < 1 AND "nation" = 'switzerland (sui)' AND "total" < 2

Question: What is the sum of Total, when Silver is greater than 1, when Nation is Germany (GER), and when Gold is less than 1?
SQL: SELECT SUM("total") FROM olympic_art_1928 WHERE "silver" > 1 AND "nation" = 'germany (ger)' AND "gold" < 1