CREATE TABLE table_4955 ("Name" CLOB, "GP-GS" CLOB, "Gain" FLOAT, "Loss" FLOAT, "Long" FLOAT, "Avg/G" FLOAT)

Which Loss is the lowest one that has an Avg/G of 3.5, and a Gain smaller than 42?
SELECT MIN("Loss") FROM table_4955 WHERE "Avg/G" = '3.5' AND "Gain" < '42'
SELECT MIN("Loss") FROM "table_4955" WHERE "Avg/G" = '3.5' AND "Gain" < '42'