Table: olympic_medals_1960
Columns: rank
nation
gold
silver
bronze
total

Question: How many totals have golds of 3, silvers of 3, and bronzes under 3?
SQL: SELECT SUM("total") FROM olympic_medals_1960 WHERE "gold" = '3' AND "bronze" < 3 AND "silver" = '3'

Question: Which nation has a rank of 7?
SQL: SELECT "nation" FROM olympic_medals_1960 WHERE "rank" = '7'

Question: What is the average bronze with silvers of 1 and totals over 2?
SQL: SELECT AVG("bronze") FROM olympic_medals_1960 WHERE "silver" = '1' AND "total" > 2

Question: How many golds does Germany have?
SQL: SELECT "gold" FROM olympic_medals_1960 WHERE "nation" = 'germany'

Question: What is the total number of bronzes with totals under 4 and ranks of 10?
SQL: SELECT COUNT("bronze") FROM olympic_medals_1960 WHERE "total" < 4 AND "rank" = '10'