Table: olympic_swimming_1996
Columns: rank
nation
gold
silver
bronze
total

Question: What is the average Gold where the Nation is Russia (rus) and the number of silver is less than 2?
SQL: SELECT AVG("gold") FROM olympic_swimming_1996 WHERE "nation" = 'russia (rus)' AND "silver" < 2

Question: What is the total where the nation is South Africa (rsa) and bronze is less than 1?
SQL: SELECT SUM("total") FROM olympic_swimming_1996 WHERE "nation" = 'south africa (rsa)' AND "bronze" < 1

Question: Which nation has 0 gold, a rank greater than 14, a total of 1, and silver less than 1?
SQL: SELECT "nation" FROM olympic_swimming_1996 WHERE "gold" = 0 AND "rank" > 14 AND "total" = 1 AND "silver" < 1