Table: athletics_1930_cac
Columns: rank
nation
gold
silver
bronze
total

Question: Tell me the lowest bronze for panama and total larger than 8
SQL: SELECT MIN("bronze") FROM athletics_1930_cac WHERE "nation" = 'panama' AND "total" > 8

Question: Tell me the average total for guatemala and bronze less than 2
SQL: SELECT AVG("total") FROM athletics_1930_cac WHERE "nation" = 'guatemala' AND "bronze" < 2

Question: Tell me the number of bronze for silver of 0 and total less than 1
SQL: SELECT COUNT("bronze") FROM athletics_1930_cac WHERE "silver" = 0 AND "total" < 1

Question: Tell me the sum of total for rank of 1
SQL: SELECT SUM("total") FROM athletics_1930_cac WHERE "rank" = 1

Question: Tell me the total number for costa rica and rank more than 8
SQL: SELECT COUNT("total") FROM athletics_1930_cac WHERE "nation" = 'costa rica' AND "rank" > 8