What Gold has a Silver greater than 30 and a Total less than 107?
CREATE TABLE table_name_40 (
    gold VARCHAR,
    silver VARCHAR,
    total VARCHAR
)
SELECT gold FROM table_name_40 WHERE silver > 30 AND total < 107
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What Gold has a Silver greater than 30 and a Total less than 107? ### Input: CREATE TABLE table_name_40 (
    gold VARCHAR,
    silver VARCHAR,
    total VARCHAR
) ### Response: SELECT gold FROM table_name_40 WHERE silver > 30 AND total < 107