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

What's the total loss for a GP-GS of 8-8 and a gain less than 416?
SELECT SUM("Loss") FROM table_12212 WHERE "GP-GS" = '8-8' AND "Gain" < '416'
SELECT SUM("Loss") FROM "table_12212" WHERE "GP-GS" = '8-8' AND "Gain" < '416'