Table: carifta_medals
Columns: nation
gold
silver
bronze
total

Question: What's the sum of Silver with total smaller than 560, a Bronze larger than 6, and a Gold of 3?
SQL: SELECT SUM("silver") FROM carifta_medals WHERE "total" < 560 AND "bronze" > 6 AND "gold" = 3

Question: What's the sum of Gold with a Bronze that's larger than 15, Silver that's smaller than 197, the Nation of Saint Lucia, and has a Total that is larger than 50?
SQL: SELECT SUM("gold") FROM carifta_medals WHERE "bronze" > 15 AND "silver" < 197 AND "nation" = 'saint lucia' AND "total" > 50

Question: What Nation has a Bronze that is smaller than 10 with a Silver of 5?
SQL: SELECT "nation" FROM carifta_medals WHERE "bronze" < 10 AND "silver" = 5

Question: What's the total number of Silver that has Gold that's larger than 0, Bronze that's smaller than 23, a Total that's larger than 22, and has the Nation of Saint Kitts and Nevis?
SQL: SELECT COUNT("silver") FROM carifta_medals WHERE "gold" > 0 AND "bronze" < 23 AND "total" > 22 AND "nation" = 'saint kitts and nevis'

Question: What is listed as the highest Silver that also has a Gold of 4 and a Total that's larger than 25?
SQL: SELECT MAX("silver") FROM carifta_medals WHERE "gold" = 4 AND "total" > 25