user: Question: What is the total number of gold medals won among nations that won more than 27 bronze and less than 305 medals total?
Columns: ['Rank', 'Nation', 'Gold', 'Silver', 'Bronze', 'Total']
Types: ['text', 'text', 'real', 'real', 'real', 'real']
Sample row: ['1', 'Switzerland', 43.0, 27.0, 27.0, 97.0]
SQL:

assistant: SELECT SUM("Gold") FROM "Table" WHERE "Bronze" > 27.0 AND "Total" < 305.0;