Schema: CREATE TABLE table_name_40 (gold VARCHAR, silver VARCHAR, total VARCHAR)
Question: What Gold has a Silver greater than 30 and a Total less than 107?
SQL: SELECT gold FROM table_name_40 WHERE silver > 30 AND total < 107